Importing Products via CSV
You can import products to your store with a .csv file. This knowledge base article describes the steps to follow to prepare the .csv file and then import it.
Preparing the CSV file
To import products, log into your admin panel. Then click Tools > Data Import to get to the import options.
Here, select your desired import:
Prepare your data and upload
To add or update items, prepare your data in .CSV file format using Excel or a similar application.
Note: If you have a data file from another system, column names can map to their expected counterparts after the file loads.
On this screen you will see a link: click to download the Sample File (used as a reference for uploading). 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.
After preparing the data, upload and select your .CSV file using the file browser. then select the appropriate options and click Load.
Importing your .csv file
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.
Next select Load up top.
Step 2 Map your data columns allows you to map the columns from your CSV file to the Spark Pay 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.
Next press Import up top and the import process begins.
Background Jobs will now appear showing the progress of the upload.
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.
List of Required Fields for Imports
Attribute Group
Attribute
- AttributeGroupID
- AttributeGroupName
- AttributeName
Campaign Coupon
- CouponCode
- CampaignCode
- IsActive
Category
Customer Type
Customer
- LastName
- FirstName
- Email
- StoreName
Directed Search
- Name
- RedirectToURL
- SearchTermList
Gift Certificates
Google Products Feed (needs to be a .txt file)
- ItemID
- ItemNumber
- ItemName
Inventory Update
Manufacturer
Microstore
Order
- StoreOrderPlacedWith
- OrderStatus
- SubTotal
- TaxesBilled
- ShippingBilled
- GrandTotal
- ShipAddressZip
- BillAddressCountry
- BillAddressState
- BillAddressZip
Product List
Product Pricing
- ItemID
- ItemNumber
- ItemName
- PriceQuantity
- Cost
- Price
Product Review
- ProductID
- PostBody
- AuthorDisplayName
- AuthorEmail
- ProductRatings
Product Variant Group
Product Variant Inventory
- ItemNumber
- VariantInventoryItemNumber
- CombinedVariants
Product Variant
- ItemNumber
- VariantGroup
- VariantName
Product
- ItemName
- CategoryList
- CategoryListIDs
- ProductStatus
- BasePrice
Reward Points
- CustomerID
- PointsEarned
- PointsRemaining
Shipping Rules
Tracking
URL Redirect
- RedirectFromUrl
- RedirectToUrl