Reference: Product Import File Format

Uploaded data can be in a CSV or Excel (.xls or .xlsx) file.

A header row is required, and the header field names and descriptions are listed below.

Please note that the column headings must be spelled exactly as displayed here.

 

Name and price

Header

Description

id
integer
The unique internal Duoplane identifier of this product. Whenever you export a list of products from Duoplane, this column will be present in the product export file.

 

If a value in this column is present, the existing Duoplane product with that ID will be updated.

This value cannot be changed. It is only used to match up the imported product with an existing Duoplane product.

name
text
The name of the product
retailer_sku
text

(For retailers only.)

The unique SKU number for the product in the retailer’s product management or inventory control system.

If you are updating existing products, you can use this column as the unique product identifier. If doing so, please ensure that this value is unique. If it is not unique, you must use the Duoplane ID (column named ‘id’) to identify existing products.

upc
text
The Universal Product Code (UPC) for this item.
mpn
text
The Manufacturer Part Number for this item.

This is relevant generally in cases when the vendor is different than the manufacturer.

price
decimal
The item’s actual retail price
price_msrp
decimal
The Manufacturer’s Suggested Retail Price
price_map
decimal
The vendor-mandated Minimum Advertised Price
taxable
boolean
 Set to “TRUE” or “1” if this item is taxable. Otherwise, set to “FALSE” or “0”. Default is true.

 

Wholesale and inventory information

Header

Description

vendor_name
text
The name of the vendor as it appears in Duoplane. If a vendor by that name is not found, Duoplane will create a new vendor record.

 

The value here must match the name exactly as it appears in Duoplane if you are trying to reference an existing vendor.

Please note the following special rules if you have configured your account to allow each product to have multiple vendors:

  • If the vendor_name value is not the name of a current supplier for this product, the vendor will be added as a new supplier for this product.
  • Supply-related columns (cost, quantity_available, etc.) will only apply to the vendor named in the vendor_name column.
  • In order to update supply-related columns (cost, quantity_available, etc.), there must be a value in the vendor_name column. If you wish to apply the same values to all vendors for a given product, set the value of the vendor_name column to “__all__” (2 underscores, followed by “all”, followed by 2 more underscores).
 
cost
decimal
The item’s wholesale cost
vendor_sku
text

The unique SKU number for the product in the vendor’s product management or inventory control system.

Specifying a Vendor SKU is especially useful for doing updates later based on vendor feeds. (E.g. pricing or inventory updates.) It also helps reduce ambiguity on purchase orders.

purchase_name
text

The name of the product as it is known to your vendor. Specify a value for this field if you and your vendor refer to this item by different names.

If present, the purchase_name name will appear on purchase orders. Leave this blank to use the value of the “name” field as the universal name of the product. 

manage_inventory
boolean

 Set to “1” or “TRUE” if you track specific inventory quantities for this item. If you do, then use the quantity_available to specify how many are available. The default for manage_inventory is false.

quantity_available
integer
 Inventory quantity currently available.
leadtime_days
integer
The number of days after an order for this item is placed that it can be expected to ship. This is used to create the promise date on the vendor purchase order. Depending on how you have configured your settings, the leadtime can be defined in either calendar or business days.

Note that this can be set at the vendor level and left blank at the product level. If set at the vendor level, use this field only to override the value set for the vendor.

vendor_leadtime_days
read only
The default leadtime days set at the vendor level.

This column will appear if you download your items out of Duoplane. Note, however, that it is there as a reference only so that you know whether this given product has a default leadtime and what it is. This field will be ignored during the upload.

backordered_until
date
For out-of-stock items, the expected in-stock date.

To be certain that dates are interpreted correctly, all dates should be in ISO 8601 format. (In other words, “YYYY-MM-DD”.) While other common formats are understood and can be parsed, using non-ISO formats may result in an incorrect interpretation of the date.

zero_cost_ok
boolean
If set to a true value (“1” or “TRUE”), Duoplane will not warn you if the product cost is zero or not set. Otherwise, Duoplane will alert you if this product has no cost.
exclude_from_inventory
_feed_updates
boolean
If set to a true value (“1” or “TRUE”), Duoplane will not update this product’s inventory attributes when the product appears on a vendor inventory feed. Set this to true if you want to selectively exclude some products from being updated by vendor inventory feeds.


Product specs

Header

Description

weight_units
text
The unit of measurement for the number in the ‘weight’ column. Recognized values are:

 

pounds: “lb”, “pounds”
grams: “g”, “grams”
kilograms: “kg”, “kilograms”
weight
decimal
The weight of the product, measured in the units specified under weight_units. If no value is set or recognized for weight_units, this is assumed to be in grams.
dimensions_units
text
The unit of measurement for the number in the various dimensions columns.
height_dimension
decimal
The height of the product, measured in the units specified under dimensions_units.
width_dimension
decimal
The width of the product, measured in the units specified under dimensions_units.
length_dimension
decimal
The length of the product, measured in the units specified under dimensions_units.
depth_dimension
decimal
The depth of the product, measured in the units specified under dimensions_units.
diameter_dimension
decimal
The diameter of the product, measured in the units specified under dimensions_units.
other_dimensions
text
A text description of any dimensions that do not fit into the predefined height, width, length, depth, and diameter fields.
custom_text_1
text
Additional text data that you want to associate with this product.
custom_text_2
text
Additional text data that you want to associate with this product.
custom_text_3
text
Additional text data that you want to associate with this product.

 

Information for managing bundles

Header

Description

product_type
text: one of ‘simple’ or ‘bundle’
Set this value to “bundle” to add or manage bundle components.
child_product_id
integer

The unique internal Duoplane identifier of the child product.

If this column is omitted, we will attempt to identify the child product by SKU using the value in the child_product_retailer_sku column.

child_product_retailer_sku
text
The unique Retailer SKU of the child product.

This column will only be used if the value of child_product_id is blank.

bundle_quantity
integer
The quantity of this component that is included in the bundle. 

 

Channel-related information

Header

Description

store_product_id
integer

The unique internal Duoplane identifier for the association between this product and a channel. Whenever you export a list of products from Duoplane with “Store Product Detail”, this column will be present in the product export file.

This column is required to update channel-related information for a single channel.

If you want to update channel-related information for all channels, you can omit this column and use the "all_[attribute name]" version of the attributes below.

inventory_sync_direction
integer
The product-level override for how to sync inventory with the ecommerce channel:
  • Leave the blank to use the vendor-level setting (if one is set) or the store-level default.
  • 0 = No sync
  • 1 = Duoplane updates ecommerce channel
  • 2 = Ecommerce channel updates Duoplane

The store_product_id column is required to update this attribute. 

all_inventory_sync_directions
integer

This is the same as the inventory_sync_direction attribute, except that it will apply to all channels for this product.

inventory_quantity_buffer
integer
The difference between the inventory quantity in Duoplane and the inventory quantity in the ecommerce channel.
A positive buffer means that the quantity in the ecommerce channel will be less than the quantity in Duoplane. For example:
  • If: Inventory quantity buffer = 5
  • And: Quantity available in Duoplane = 20
  • Then: Quantity to sync to the ecommerce channel = 15

The store_product_id column is required to update this attribute. 

all_inventory_quantity_buffers
integer

This is the same as the inventory_quantity_buffer attribute, except that it will apply to all channels for this product.

Other information

Locking or unlocking attributes

See this article for more information on locked attributes.

Header

Description

_add_to_locked_attributes
text

A comma separated list of product attributes that should be locked.

 

Note the underscore at the beginning of this field.

_remove_from_locked_attributes
text

A comma separated list of product attributes that should be unlocked.

 

Note the underscore at the beginning of this field.

 

Deleting records

Header

Description

_delete_inventory
boolean
If set to a true value (“1” or “TRUE”), Duoplane will delete the inventory record associated with this vendor. The column vendor_name or vendor_id must be present if you are deleting an inventory record. Please use this carefully as this cannot be undone.

 

This does not delete the product from the database, but rather removes the association with the specified vendor.

 

Note the underscore at the beginning of this field.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.