Product Information Summary For Importing and Exporting

Product Information Summary For Importing and Exporting

Shopit has a standard data structure of 37 fields. You can see the data structure for each product below:

You can easily add additional columns/fields for your data here: Using Custom Product Fields


FIELDCSV COLUMNGLOBALREQUIREDFIELD TYPEINSTRUCTIONS
Product IdGlobalYesintegerRequired to update details for the product. This must be a unique number.
Product TypeGlobalYesstringEither single, variation, variant or kit.
Parent IdGlobalintegerRequired for variants and is the id of the parent variation.
SKUGlobalstringIf assigned, all single, kits and variants must have a SKU.
NameGlobalstringThis field is ignored for variants.
WeightGlobaldecimalWeight in grams.
BrandGlobalstring
RRPGlobaldecimalRRP price in the format 0.00.
Visibility/StatusstringEither purchasable, unpurchasable, disabled or unavailable for single/variants/kits and either purchasable or disabled for variations.
Sold Out StatusstringApplies to single and variants only. Value must be in the format "when_sold_out/when_back_in_stock", for example, disable/purchasable. Options are purchasable, unpurchasable, disabled or unavailable.
TaxablestringEither y or n for singles, kits or variations.
PricedecimalPrice in the format 0.00
Discount PricedecimalDiscount price in the format 0.00
Cost PriceGlobaldecimalCost price in the format 0.00
Reorder LevelGlobalinteger
Reorder QtyGlobalinteger
Option 1GlobalstringFor variations, this should be in the format OptionLabel[Comma-separated list of options], e.g. Size[Small,Medium,Large].
Option 2GlobalstringFor variations, this should be in the format OptionLabel[Comma-separated list of options], e.g. Size[Small,Medium,Large].
Option 3GlobalstringFor variations, this should be in the format OptionLabel[Comma-separated list of options], e.g. Size[Small,Medium,Large].
Option 4GlobalstringFor variations, this should be in the format OptionLabel[Comma-separated list of options], e.g. Size[Small,Medium,Large].
Option 5GlobalstringFor variations, this should be in the format OptionLabel[Comma-separated list of options], e.g. Size[Small,Medium,Large].
Primary Category Idinteger
URL Handlestring
Custom Namestring
Descriptionstring
Meta Titlestring
Meta Descriptionstring
Meta KeywordsstringA comma-separated list of keywords.
EANGlobalstring
MPNGlobalstring
UPCGlobalstring
ASINGlobalstring
Image 1GlobalstringUrl of an image
Image 2GlobalstringUrl of an image
Image 3GlobalstringUrl of an image
Image 4GlobalstringUrl of an image
Image 5GlobalstringUrl of an image