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
- Select either Comma delimited or Tab delimited for Data Delimiter. The file that is being uploaded must be in one of these formats.
- 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.
- Click the Choose File button.
- Navigate to and select your file.
- Click the Open button.
- Click the Upload button.
- 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.
|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.||?||?||?|