Import Products
Pro-Logo.png

Use the Import Products page to import a list of Products, in .csv or .txt file formats.

If you are not already signed up for this feature, please contact your Merchant Service Provider or PayTrace Support at moc.ecarTyaP|troppuS#moc.ecarTyaP|troppuS.

How to Use This Page

  1. Select either Comma delimited or Tab delimited for Data Delimiter. The file that is being uploaded must be in one of these formats.
  2. If the column positions in your file match the order of the Data Values listed, leave the Data Values in the order listed. If the column positions in your file are in a different order, change the Data Values to match the order in your file.
  3. Click the Choose File button.
  4. Navigate to and select your file.
  5. Click the Open button.
  6. Click the Upload button.

Detailed Help

Links

Download the default product import template
To download a product template in .csv format for use to upload products CLICK HERE.
View the product import data definitions
To view a .pdf file that lists the data definitions for each field CLICK HERE.

Data Definitions

Name Description Format Length Required
Product_ID Each product in your product database must have a unique identifier. Alpha-numeric 1-50 YES
Title The title or name of the product that the customer sees in the shopping cart and sales receipts. Alpha-numeric 1-50 YES
Category The category ID of the category that the product should be grouped with. This field is optional and may be obtained from the Modify Category page. Numeric 1-8 NO
SKU Product or part number that relates it to your supplier, inventory, or accounting system. Alpha-Numeric 1-50 YES
Description Description of the product that the customer sees in the shopping cart and sales receipts. Alpha-Numeric 1-255 YES
Price Base amount the shopping cart will charge your customers for each of this product in the shopping cart. Numeric 1-12 YES
Sale_Price Sale price the shopping cart will charge your customers if the On_Sale attribute is set to Y. Numeric 1-12 YES
On_Sale Specifies whether to use the Sale_Price or Price amounts. Alphabetic 1 YES
Is_Viewable Specifies whether customers may view and purchase the product. Alphabetic 1 YES
Weight Weight of the shipped product by itself. Used to calculate shipping cost at the time of the checkout. Provide 0 if the product is not shipped. Numeric 1-4 YES
Continue_Shopping_URL Web address that is offered to customers who add this product to the shopping cart and wish to continue shopping. Must be a valid URL prefaced with 'http:' Alpha-numeric 11-255 YES
Secret_URL Web address that is provided to customers only after their transactions are approved. Useful for downloadable or subscription-based products. Must be a valid URL prefaced with 'http:' Alpha-numeric 11-255 NO
Inventory_Count Total count of the product in your inventory. Used to prevent purchases of out-of-stock products. Up-to-date inventory count will be displayed on your email confirmations. Numeric 1-6 YES
Source_ZIP Zip code where the product will be shipped from. Used to calculate shipping cost at time of checkout. Numeric 5, 9 YES
TAX_Applies Indicator used by the shopping cart to determine if tax should be applied to an order based on the customer's shipping zip code. Provide Y if tax applies or N or null if tax does not apply. Alphabetic 1 YES
Shipping_Applies Indicator used by the shopping cart to determine if the customer's shipping information should be requested for an order. Provide Y if shipping applies or N or null if shipping does not apply. Alphabetic 1 YES
Product_Field1 Value of the first product discretionary data type. ? ? ?
Product_Field2 Value of the second product discretionary data type. ? ? ?

Other Information

Comma Delimited file
Comma Delimited definition Wikipedia Definition of Comma Delimited
Tab Delimited file
Tab Delimited definition Wikipedia Definition of Tab Delimited