- Overview
- Choosing your import type
- Prepare your .csv file for uploading
- Mapping your Data Columns
- Validate & Import your data
Overview
Importing data into your store using a .csv file (comma separated value), is a great way to speed up adding or updating information to your store.
AmeriCommerce has many different types of imports, to help you get your data into your store quickly and easily!
Many programs for text editing and word processing can handle a .csv file. One of the most popular is Excel from Microsoft.
This knowledge base article describes the steps to follow to prepare the .csv file and then import it.
In this example, we will be using a product import.
Choosing your import type
To import products, log into your admin panel. Then click Tools > Data Import to get to the import options.
Here, select your desired import:
After selecting your desired import type, click 'Next'.
Prepare your .csv file for uploading.
To add or update items, prepare your data in .CSV file format using Excel or a similar application.
If you are just getting started, there are Sample Files shown to the right, which can be used as a reference for your uploads.
Just click the link to download a CSV file that you can use to import your product data. Some columns need special formatting, so it may not be possible to map all fields without modification.
Note: If you have a data file from another system, column names can be mapped to their expected counterparts after the file loads.
Pro Tip: On Step 2 of any import, you can click on "View Field Definitions", to see all available import columns and definitions for that import type.
Once your file is ready you can drag and drop it onto the screen or select the “Insert From” button. This will set your file for upload.
Mapping your data columns
Step 2 Map your data columns allows you to map the columns from your CSV file to the AmeriCommerce online store . If you used our template, you can skip this step because all the data is properly categorized.
If you have your own format, pick one of your columns on the left and select our matching column. If you wish, you can save the current mapping scheme for future use at the top of the page. Next time you come to import the same file, you will not have to re-map the data again. Some fields in the column map are required however. View the list at the end of this article for all required data fields.
Click 'Next' to reach the Validation/Import page.
Validate & Import your data
On this screen, you can choose to run a validation on your import, to check for errors, so they can be corrected before your import.
NOTE: Validating an import containing new categories will create the categories during validation. This is required to properly validate the entire file.
Click on the 'Validate' button, to begin the process.
Background Jobs will now appear showing the progress of the validation.
If your file validated with No Errors, Awesome! Now your ready to Import.
Click the 'Import' button to begin your import, the background jobs area will display the import progress, with any errors that are encountered.
If your file imported with No Errors:
Congratulations! You have imported new products into your catalog. Use similar methods with the Import Wizard for handling customer and order lists, tracking information, and inventory data.
Note: In order to remove the values for field in the database you will need to place <<DELETE>> in the corresponding field on the import.
List of Required Fields for Imports
Attribute Group
- AttributeGroupName
Attribute
- AttributeGroupID
- AttributeGroupName
- AttributeName
Campaign Coupon
- CouponCode
- CampaignCode
- IsActive
Category
- CategoryName
Customer Type
- CustomerType
Customer
- LastName
- FirstName
- StoreName
Directed Search
- Name
- RedirectToURL
- SearchTermList
Gift Certificates
- Code
- Balance
- StoreName
Google Products Feed (needs to be a .txt file)
- ItemID
- ItemNumber
- ItemName
Inventory Update
- *None Required*
Manufacturer
- ManufacturerName
Microstore
- MicroStoreName
Order
- StoreOrderPlacedWith
- OrderStatus
- SubTotal
- TaxesBilled
- ShippingBilled
- GrandTotal
- ShipAddressZip
- BillAddressCountry
- BillAddressState
- BillAddressZip
Product List
- ProductListName
Product Pricing
- ItemID
- ItemNumber
- ItemName
- PriceQuantity
- Cost
- Price
Product Review
- ProductID
- PostBody
- AuthorDisplayName
- AuthorEmail
- ProductRatings
Product Variant Group
- VariantGroupName
Product Variant Inventory
- ItemNumber
- VariantInventoryItemNumber
- CombinedVariants
Product Variant
- ItemNumber
- VariantGroup
- VariantName
Product
- ItemName
- CategoryList
- CategoryListIDs
- ProductStatus
- BasePrice
Reward Points
- CustomerID
- PointsEarned
- PointsRemaining
Shipping Rules
- shippingMethodID
Tracking
- OrderID
URL Redirect
- RedirectFromUrl
- RedirectToUrl