Skip to main content

What fields can I use in the remote store Listings CSV/JSON file?

Listing and variant fields for remote store listings files, with CSV and JSON samples

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
}
]
}
]
Did this answer your question?