Hi,
Please check the following
Listing rules templates can be assigned to products in bulk using the import system. The only required fields in your CSV import file are:
- SKU
- eBay Items List (the ID of the rules template)
Tip: Use the simple export process to generate a CSV file with your product SKUs.
The following additional fields can also be imported to the eBay Items List field as a pipe (|) delimited string. This is only required if you want to define eBay category or listing design template details on a per product basis, rather than having them determined by the listing rules template or category mapping. Each field, however should end in a semicolon (;) to denote the end of the record.
- Design Template ID - your eBay listing template design ID
- eBay Category 1 - the primary eBay category ID
- eBay Category 2 - the secondary eBay category ID (incurs an additional charge)
- eBay Store Category 1 - your primary eBay store category ID
- eBay Store Category 2 - your secondary eBay store category ID
Important: You must use numeric IDs for the eBay category and eBay store categories, not eBay category names.
Once you have populated your CSV file with data you can begin the import process.
Ensure Ebay Items List is selected from the second database field name field. Map your template ID to this field.
On the Update Options tab, select either Update Existing Products Only or Add New / Update Existing Products from the How Do You Want To update your Database dropdown.
Within the Other Options section, select Replace Existing Record from the eBay Items Update Options dropdown.
This means that if the product already has a rules template applied to it, a second won’t be added and instead the original will be removed first.
If you have each of the required fields in separate fields in your spreadsheet, you can combine them together into a string using the Join
To feature in the field mapping to link different columns in your file together. e.g
[Listing Template ID]|[Design Template ID]|[eBay Category 1]|[eBay Category 2]|[eBay Store Category 1]|[eBay Store Category 2]
It also uses the Static Value function to insert the pipe (|) separators, and the semicolon (;) to indicate the end of the record.
