Import Products

Upload at inventory > products. Use the Product Import button.

Sample file: click here

Use the following fields (random order):

Fields Mandatory Type Description
sku yes Text(64) Your productnumber
name yes Text(255) Productname
gtin no Text(255) GTIN (EAN / UPC)
brand no Text(64) Product Brand
mpn no Text(255) Manufacturer Partnumber
cycle_class yes Text(1) A,B,C remove the field to import with class C
replenishment_policy no Numeric none = 0, minmax = 1, forecast = 2, stockentity = 3. If column not exist, value is set to 1
stock_entity_id no Numeric Clougistic entity that will manage the stock
category no Text(255) Category to group products
weight no Numeric used for picking calculation, use same unit (g of pounds) as in warehouse configuration
length no Numeric used for picking calculation, use same unit (m of inch) as in warehouse configuration
width no Numeric used for picking calculation, use same unit (m of inch) as in warehouse configuration
height no Numeric used for picking calculation, use same unit (m of inch) as in warehouse configuration
qty_min no Numeric minimum stock quantity if replenishpolicy is minmax
qty_max no Numeric maximum stock quantity if replenishpolicy is minmax
stock_cost no Numeric if replenishpolicy is forecast
purchase_cost no Numeric if replenishpolicy is forecast
service_level no Numeric if replenishpolicy is forecast
forecast_period no Week, Month, Quarter, Year if replenishpolicy is forecast
forecast_periods no Numeric if replenishpolicy is forecast
forecast_cycles no Numeric if replenishpolicy is forecast
sku_predecessor no Text(64) sku used as historical forecastdata for this sku
default_leadtime no Numeric if replenishpolicy is forecast
allocation_override no Numeric 0. None, 1. Direct to Reservation
image_url no Text(255) Full URL path to public access image
tracking_required no Numeric 0. Not required, 1. Required
mode no Text(255) create_rollback (on error rollback to state before import)
create (create records without errors without feedback)
update_rollback (on error rollback to state before import)
update (create records without errors without feedback)