Skip to main content
All CollectionsSKULabs API
What fields can I use in the remote store Listings CSV/JSON file?
What fields can I use in the remote store Listings CSV/JSON file?
Updated over a week ago

The remote store listings csv/json file can be used to import products in association to a store that is unsupported natively by SKULabs. The following fields can be used in the remote store listings import.

Here is a sample CSV,

Listings

listings_header (required) - Use "listings" under this column to indicate a particular row is an individual listing or parent listing of variants
Active - Is this listing active?
Name (required) - Name of the product
SKU (required) - SKU for the product
UPC - 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 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 indicate a particular row is an individual listing or parent listing of variants
Active - Is this listing active?
parent_sku (required) - SKU of parent listing
Name (required) - Name of the variant
SKU (required) - SKU for the product
UPC - 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 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

Here is a sample JSON format listing:

[{
active: true,
name: 'Purple Spoon',
sku: 'pplspoon',
barcode: '070030511753',
weight: 3,
weight_unit: 'oz',
length: 3,
width: 3,
height: 1,
dimensions_unit: 'in',
cost: 6.99,
retail: 19.99,
on_hand: 279,
alert: 25,
location: 'A-1-B',
image: 'https://cdn.shopify.com/s/files/1/1018/7267/products/purple-spoon_large.png?v=1444335946',
variants: [{
sku: 'coloredspoon-mint',
name: 'Mint Spoon',
barcode: '07003022754',
weight: 3,
weight_unit: 'oz',
length: 3,
width: 3,
height: 1,
dimensions_unit: 'in',
cost: 6.49,
retail: 19.49,
on_hand: 77,
alert: 25,
location: 'C-1',
},
{
sku: 'coloredspoon-magenta',
name: 'Magenta Spoon',
barcode: '07003022755',
weight: 3,
weight_unit: 'oz',
length: 3,
width: 3,
height: 1,
dimensions_unit: 'in',
cost: 6.49,
retail: 19.49,
on_hand: 77,
alert: 25,
location: 'A-2-B',
}]
},
{
active: true,
name: 'Colored Spoon',
sku: 'coloredspoon',
upc: '07003022753',
image: 'https://cdn.shopify.com/s/files/1/1018/7267/products/purple-spoon_large.png?v=1444335946',
}
]

Did this answer your question?