By using a bulk uploader, you can upload Golden Products and Variants in bulk into the central product database. The product information that already exists within the database is also updated according to the recently uploaded data.
To create a spreadsheet to upload Golden Products in bulk, you can either:
- Create it from scratch by following the documentation below.
- Use an export from the central product database as the template.
In the following section, products refer to Golden Products and product items or items refer to Golden Variants.
To upload your products in bulk, sign in to the operator portal and navigate to ADVERTS > Central Product Database > Manage Data > Bulk Upload.
Products are the "grouping" for product items. For instance, there may be a Giant Cypress DX bike product. The product items for this product are the color and size combinations. Example:
- Product: Giant Cypress DX
- Item: Colour: Blue / Size: Small
- Item: Colour: Blue / Size: Medium
- Item: Colour: Blue / Size: Large
Products serve as the "template" for an advert/product and items are the template for a variant.
Rules for updating existing data
- Products: Product ID OR a full combination of Name, Taxon, Brand and Year have to match the existing row.
- Using Product ID: You specify a "Product ID" column of "11114". If there is a product with this ID, it will be updated with the data from that row in the spreadsheet. The Product ID is generated by our system when a new product is created.
- Without Product ID: You do not specify a "Product ID" column, but you do specify a "Name", "Taxon", "Brand" and "Year" column. If there is data in the database matching all four of these fields then that product will be updated.
If you have rows in your CSV with matching "Name", "Taxon", "Brand" and "Year" but different (e.g.) Gender, only one product is created when the CSV is imported. - Items: Item ID OR one of UPC, SKU or EAN needs to match existing row.
- Using Item ID: You specify an "Item ID" of "1". If there is an item with this ID, it will be updated with the data from that row in the spreadsheet.
- Without Item ID: You specify one of a SKU, UPC or EAN. If there is data in the database matching one of these then the item will be updated.
If the above does not match, then a new product or item is created.
Product fields
To create a product, the Uploader requires a taxon, brand, and name. This table shows the product fields in the spreadsheet:
| Field | Description |
| External ID | The external systems' ID for the product. |
| Taxon | The taxon for the product. |
| Taxon 1, Taxon 2, Taxon 3 | The taxons for the product. Used as an alternative to the Taxon field. |
| Brand | The brand for the product. |
| Product Name | The name of this product. |
| Product Description | The description of the product. This field supports Markdown. |
| Specifications | The specifications for the product. This field supports Markdown. |
| Base Price | The price for the product. Must be specified as a decimal price. For example, 123.45. |
| Year | The year the product was manufactured. |
| Gender |
One of "male", "female" or "unisex". |
| Product Tax Code | Tax code of the product. |
| Recommended Retail Price | The recommended retail price of the product. The value must be greater than or equal to 0. |
| Product Document 1 to 5 |
You can include the document URL in this field. For example, PDF. |
Option Values
To specify option values for this product, you can include them like this:
| Variant Option Name 1 | Variant Option Value 1 |
| ------------- |-------------|
| Flame Decal | Red |
You must specify option types from the product's taxon and pick an option value from that list. This is not a free-form field.
Images
To specify images for this product, you can specify this:
| Item Image 1 | Item Image 2 |
| ------------- |-------------|
| http://example.com/image.jpg | http://example.com/image-2.jpg |
You can upload as many images as you like. This is not restricted to just 4 images like the advert importer is.
Item Fields
To create an item, you can use these fields:
|
Field |
Description |
| Item ID | The database's ID for this item. Left blank for the new item. |
| Item UPC | The item's UPC (Universal Product Code). Barcode in non-EU countries. |
| Item EAN | The item's EAN (European Article Number). Barcode in EU countries.| |
| Item SKU | The item's SKU, typically how the manufacturer refers to the item. Does not have to be unique across all items. |
| Item Name | The item's name. Optional. |
| Item Price | The item's price. Used only if it differs from its product's. |
| Item Weight | The item's weight. |
| Item Length | The item's length. |
| Item Depth | The item's depth. |
| Item Width |
The item's width. |
| Item Notes |
Notes for the item, if there are any. |
| Item Size |
Size of the item. The value must be greater than or equal to 0. |
|
Item Unit |
The unit of measurement to be used. For example, “Gram”. |
|
Item Comparative Size |
Number greater than or equal to 0. |
|
Item Comparable Unit |
Text matching the name of any existing measurement unit. For example, “Gram”. |
|
Item Recommended Retail Price |
The recommended retail price of the item. The value must be greater than or equal to 0. |
|
Item Tax Code |
Tax code of the item. |
|
Item Active Status |
The value must be True if the item is active and false if inactive |
Option Types
To specify option values for this item, you can include them like this:
| Variant Option Name 1 | Variant Option Value 1 |
| ------------- |-------------|
| Flame Decal | Red |
You must specify option types from the product's taxon and pick an option value from that list. This is not a free-form field.
Images
To specify images for this item, you can specify this:
| Item Image 1 | Item Image 2 |
| ------------- |-------------|
| http://example.com/image.jpg | http://example.com/image-2.jpg |
Images should be unique to the items. For instance, if you're uploading an image for a "Red Bike" then you should attach an image that shows a red bike.
Related articles