The remote store listings CSV/JSON file can be used to import products for a store that SKULabs does not support natively. The following fields can be used in the remote store listings import.
How a CSV file is laid out
The first column of every row tells SKULabs what the row is. Use these words exactly, in lowercase:
listings_header: the column names for listings
variants_header: the column names for variants
listing: one product (or the parent of a group of variants)
variant: one variant of the listing row above it
Put both header rows first, then each listing row followed by its variant rows. Listings with no SKU are skipped.
Sample CSV (add more columns from the lists below as needed):
listings_header,sku,name,barcode,on_hand
variants_header,sku,name,barcode,on_hand
listing,pplspoon,Purple Spoon,070030511753,279
listing,coloredspoon,Colored Spoon,,
variant,coloredspoon-mint,Mint Spoon,07003022754,77
variant,coloredspoon-magenta,Magenta Spoon,07003022755,77
Listings
listings_header (required) - Use "listing" under this column to mark a row as a product or the parent of a group of variants
active - Is this listing active? Blank, true, yes or active means active; anything else means inactive.
name (required) - Name of the product
sku (required) - SKU for the product
barcode - Barcode/UPC/ISBN/etc for the product
weight - A numeric value representing the weight of the product
weight_unit - oz/lb/g/kg
length - Numeric length
width - Numeric width
height - Numeric height
dimensions_unit - cm/m/in/ft
cost - Numeric cost of the product to acquire
retail - Retail price of the product
on_hand - Your current available on hand quantity
alert - The level of on hand under which this item will show up in the low inventory report
location - Name of the location this product should be assigned
image - URL to an image for this product
Variants
variants_header (required) - Use "variant" under this column to mark a row as a variant of the listing row above it
parent_sku - SKU of the parent listing (for your reference; in a CSV the variant belongs to the listing row above it)
All listing fields above can also be used on variants: active, name (required), sku (required), barcode, weight, weight_unit, length, width, height, dimensions_unit, cost, retail, on_hand, alert, location and image.
JSON format
A JSON file must be an array of listings. Variants go in a variants array inside their parent listing. Sample:
[
{
"sku": "pplspoon",
"name": "Purple Spoon",
"barcode": "070030511753",
"weight": 3,
"weight_unit": "oz",
"cost": 6.99,
"retail": 19.99,
"on_hand": 279,
"location": "A-1-B"
},
{
"sku": "coloredspoon",
"name": "Colored Spoon",
"variants": [
{
"sku": "coloredspoon-mint",
"name": "Mint Spoon",
"barcode": "07003022754",
"on_hand": 77
},
{
"sku": "coloredspoon-magenta",
"name": "Magenta Spoon",
"barcode": "07003022755",
"on_hand": 77
}
]
}
]
