About the bulk product upload spreadsheet

*Title Description

This is the product title displayed to the customer. Titles are limited to 160 characters. This item corresponds to the Title in the individual product listing.

*Main Description

This is the description displayed to the customer on the website. This item corresponds to the Description in the individual product listing. 

Specifications

Enter specifications for tangible characteristics, such as ‘battery operated’ or ‘portable’. This item corresponds to the Specifications in the individual product listing. This field is optional.

New or Used

Indicate whether a product is in New or Used condition. 

Product/advert dimensions

These details assist with calculating shipping for third parties and at checkout. They correspond to the Dimensions (length x width x depth) and weight fields in the individual product listing. Optional.

Fields are:

• Advert Shipping Width
• Advert Shipping Length
• Advert Shipping Depth
• Advert Shipping Dimension Unit
• Advert Shipping Weight
• Advert Shipping Weight Unit

Year

This field is optional and can be used for products such as wine where the year is important to note.

Youtube Video URL

Upload a YouTube video URL.

Custom Video URL

Upload a custom video URL, such as Vimeo.

Custom Video Thumbnail

Upload a custom video thumbnail. Images have to be uploaded as a public URL link to the image.

Ad ID

Marketplacer Advert ID. You will not need to fill this column in when uploading new products, but the column needs to be present in the import file. Ad IDs are automatically assigned to products when they are created in the marketplace.

Custom Code

Internal use only. Used by sellers to reference their internal naming system.

Advert Tax Code (US Only)

Tax codes are used by third-party sales tax calculation products, and are a way to determine the applicable tax a buyer must pay. This item corresponds to the "Tax Code" in the individual product listing creator. This function will only apply to US clients.

External ID 

This can be used if the seller or operator has their IDs for the products, for example, product IDs generated in product management software like Shopify.

Publish Advert (yes/no)

Publish the product or leave it unpublished. Note that publishing a product triggers additional data validation.

Publish Variant (yes/no)

Publish the variant or leave it unpublished. 

Barcode

GTIN Barcodes must be unique and valid. This item corresponds to the "Barcode" in the individual product listing. This field is optional. 

SKU

Listing/Advert SKU. This item corresponds to "SKU" in the individual product listing. This field is optional.

Third-Party Fulfilment ID

A third-party fulfillment partner ID such as Shippit or Fulfilio, if applicable. This field is optional.

Variant ID 

For downloaded products, this is the ID associated with any product variants (for example, the same product in a different color). Variant ID does not need to be added for new variants. Variant IDs are automatically assigned to the products when they are created in the marketplace.

Variant External ID

Any Variant External IDs. This field is optional and is generally only used if a seller or operator has their ID classification system for variants, such as a Shopify ID.

*Category, Category 2, Category 3, Category 4, Category 5 (required when publishing)

This is the Marketplacer-defined category and subcategories for the Marketplacer product taxonomy. The number of Type fields required/used depends on the taxonomy. If you are using bulk upload to map products, you need to enter the product taxonomy exactly as it is set up in Marketplacer else you will get an error. If you are unsure, contact the marketplace operator.

*Brand (mandatory when publishing)

The brand is the maker of the product. Brand names are validated only when "Publish Advert (yes/no)" is set to Yes. The brand names must match the brand names in Marketplacer if they already exist. In that case, ensure that the spelling and capitalization are exactly similar to the existing ones in Marketplacer. Leave blank if you do not use brands. 

Gender (m/f/unisex)

Set whether the product is for men, women, or is unisex. This appears as a feature on the page. The customers can search by gender (unless disabled). This will default to unisex if left blank.

Category before mapping 

If you create products from scratch through the bulk upload spreadsheet, you can disregard this field. However, if you use the bulk upload spreadsheet for mapping purposes only (after a product is imported through MConnect or API), this field helps know what to map a product into.

Brand before mapping

Disregard this field.

Variant Option Name 1 

This is the product variant name. For example, Color. 

Variant Option Value 1

This is the product variant value. For example, Red. 

Variant Option Name/Variant Option Value 2, 3, 4

Use these options if products have more than one variant. For example, color and size. The option value names must match what is already defined by the marketplace owner.

Variant Options before mapping

Disregard this field.

Variant Notes / Notes

Variant Notes can help during product mapping. For example, enter ‘Color: Red’. There is no need to update this when adding or updating an advert. 

The Notes column is the equivalent Note field on the product (advert).

Feature Option Type

Name of a product feature, for example, Material. Similar to variants, the feature names, and values must match the setup in Marketplacer. For instance, if a seller’s product has the feature ‘Material’ and the marketplace does not, an error occurs when uploading the product. This is validated against a list of values maintained by the operator. 

Feature Option Value 

Enter a value for each feature option name. For example, oak or silk. This is validated against a list of values maintained by the operator.  

Product Details

Use this field to enter any optional Product features, also known as Free Text or Dropdown option types. The Marketplacer operator must enable this option for categories. You must use a key value format in this field, similar to Key: Value, where the Key is the Option Type and the Value is the Option Value. Dropdown values are validated against what the operator has enabled. Key and values are not case sensitive and multiple values are separated by a comma (,).
Example:

Breed: Poodle, Age Group: Adult 

Product Features

You can enter product features in a list format, separated by commas. 

Example:

Silk Material, Machine Washable

This item corresponds to Features in the individual product listing. This field is optional.

Tax codes are used by third-party sales tax calculation products and are a way to determine the applicable tax a buyer must pay. This function only applies to US clients.

Payment options

If the operator allows deposit payments, this determines the payment options offered to the shopper such as:

• Full payment (full_payment)
• Full payment or deposit (full_payment_or_deposit)
• Deposit only (deposit_only).

Stock level

Specify the number of current products or new products. This defaults to zero if unlimited stock is selected. This item corresponds to Quantity in the individual product listing creator. If stock is managed through an integration, such as Shopify, you must ensure you are not overriding the inventory data managed through the integration.

Unlimited Stock (Yes/No)

The stock can be set to unlimited by entering Yes. Unlimited means that the product never runs out of stock. You might only use this for things like services.

Variant Price

The price of any variants. For example, an oak table may cost more than an iron table of the same design. If bulk updating advert prices, ensure that the price and the variant price are updated. 

Variant Pricing Model
Use the Variant Pricing Model column to mark variants as wholesale by entering WHOLESALE. This works with the Variant Wholesale Price column to set the wholesale price.

Variant Sale Price

The sale price of any variants. If bulk updating advert prices for a sale, ensure both the price and the variant price is updated. 

*Base Price

This is the core price of the product. This item corresponds to Base Price in Marketplacer’s product listing.

On Sale Price

This will show as the listing or advert sale price, and will appear on the site when added. This field is optional. This field corresponds to Sale Price in Marketplacer’s individual product listing.

Price Type

Enter price types if applicable. E.g. POA, From. Only use if this feature is switched on in Marketplacer. This field corresponds to Price type in Marketplacer’s individual product listing. This field is optional.

Price Unit

Enter a price unit if applicable, e.g Yard, Sq Meter, kilogram. Only use if this feature is switched on in Marketplacer. This field is optional.

Sale Type

Set whether the product is bought online or click and collect (format as: buy_online_or_click_collect). This item corresponds to Availability in the individual product listing creator. Please note: the seller will need to have e-commerce enabled to set the Sales Type as buy_online. If they do not an error will occur. 

Third Party Fulfilment Provider

Name of the third party fulfilment partner (e.g. Shippit, Fulfilio). This field is optional. 

Variant Shipping Profile ID

This is the ID of the shipping profile that applies to the variant. This field is mandatory when shipping rules are in use, it is otherwise optional.

Variant Dimensions

These details assist with calculating shipping for third parties and at checkout. They correspond to the Dimensions (length x width x depth) and Weight fields in the individual variant listing. Optional.

Fields are: 

• Variant Shipping Width
• Variant Shipping Length
• Variant Shipping Depth
• Variant Shipping Dimension Unit
• Variant Shipping Weight
• Variant Shipping Weight Unit

These details assist with calculating shipping for third parties and calculation at checkout. This is optional. 

Domestic Shipping Cost

Sellers can set the domestic shipping cost per product. This field is optional.

Image (Main)*

Set the main product image. One main image is mandatory. Images have to be uploaded as a public URL link to the image (not a thumbnail). This corresponds to Product Images in the individual product listing. Check with your marketplace operator about image requirements.

Image 02-20

A seller can upload up to 20 images. Please note: images have to be uploaded as a public URL link to the image (and not a thumbnail). This corresponds to Product Images in the individual product listing.

Variant Image (Main)

Set the main variant image. Please note: images have to be uploaded as a public URL link to the image (not to a thumbnail).

Variant Image 02-20

A seller can upload up to 20 images. Please note: images have to be uploaded as a public URL link.

Please note: When updating images for existing products and variants the newly uploaded images will replace the images previously stored on the advert or variant. It is not possible to update only specific existing images. 

Media

Document01-05 You can attach up to five PDF files to an advert.

Please note: When updating documents for existing products the newly uploaded documents will replace the documents previously stored on the advert. It is not possible to update only specific existing documents. 

Vetting

Product adverts can be vetted by the operator. These fields appear in the CSV download file and the template CSV file.

• Vetted
• Vetting Rejected At
• Vetting Rejected Reason

Advert Status

Mapped - True/False. Has the product mapping been completed?

Errors - Validation errors in the product (advert) or variants.

The following fields are not included in the template file, but they are valid column headings for a product upload file. Contact us if you want more detail.

Wholesale pricing

Wholesale Price

Recommended Retail Price

Wholesale Promo Price

Wholesale Promo Price Start At

Wholesale Promo Price End At

Variant Wholesale Price

Variant Recommended Retail Price

Variant Wholesale Promo Price

Variant Wholesale Promo Price Start At

Variant Wholesale Promo Price End At

Variant Sizing

Variant Item Size

Variant Item Unit

Variant Comparative Size

Variant Comparative Unit

Sale pricing (if effective)

Sale Price Start At

Sale Price End At

Variant Sale Price Start At

Variant Sale Price End At

TGA labelling

Enable Therapeutic Goods (TGA) Labelling (Yes/No)

Variant TGA Warning

Variant Consumer Medicine Information

Variant Ingredients

Variant Directions

Variant Storage Instructions

Variant Suitable For/Indications

Variant Product Warnings

Variant Allergen Contains

Variant Allergen May Be Present

Variant Nutrition Information

Origin country

Origin Country Code (ISO 2)

Purchase limits

Min Purchase Quantity

Max Purchase Quantity

Variant Min Purchase Quantity

Variant Max Purchase Quantity

Created At and Updated At 

Advert Created At - Timestamp when the advert was first created

Advert Updated At - Timestamp of the last update to the advert

Variant Created At - Timestamp when the variant was first created

Variant Updated At - Timestamp of the last update to the variant