Importing Data

Follow

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

  • AttributeGroupName

 

Attribute

  • AttributeGroupID
  • AttributeGroupName
  • AttributeName

 

Campaign Coupon

  • CouponCode
  • CampaignCode
  • IsActive

 

Category

  • CategoryName

 

Customer Type

  • CustomerType

 

Customer

  • LastName
  • FirstName
  • Email
  • 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
Have more questions? Submit a request

Comments