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
    • Related Articles

    • Improving your product descriptions layout (when importing from a CSV)

      Using a CSV to import products Importing via a CSV is the most efficient method for creating lots of products in Shopit. Once you understand the CSV format, and the required information rules and parameters, you can create thousands of products very ...
    • Importing Images

      When importing your products from another connected source (e.g. Shopify), or via the import/export spreadsheet function, you can choose to import the images Requirements Your spreadsheet should have a column labelled 'Image URL' or similar That ...
    • Importing products from another ecommerce platform

      In Shopit, you can choose from 3 ways to enter your products: Manual add (there are 2 examples you can edit) Import a csv using our template Import from another platform e.g. Shopify It is important to remember that whilst Shopit has a default ...
    • Using Custom Product Fields

      A big advantage of developing your website on Shopit is the ability to create custom fields for both products and orders. These product custom fields are an extension of our standard Shopit database, and can be used to customise the look and feel of ...
    • Product Types

      Shopit lets you sell different types of product which can be classified as follows: Single This item has no variation and is a single entity - there is no additional choice for the customer to make. Examples: Bouquet of 12 red roses Black Leather ...