Importing Data


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



  • AttributeGroupID
  • AttributeGroupName
  • AttributeName


Campaign Coupon

  • CouponCode
  • CampaignCode
  • IsActive



  • CategoryName


Customer Type

  • CustomerType



  • 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*



  • ManufacturerName



  • MicroStoreName



  • 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


  • ItemName
  • CategoryList
  • CategoryListIDs
  • ProductStatus
  • BasePrice


Reward Points

  • CustomerID
  • PointsEarned
  • PointsRemaining


Shipping Rules

  • shippingMethodID


  • OrderID


URL Redirect

  • RedirectFromUrl
  • RedirectToUrl
Have more questions? Submit a request