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 |
|---|---|
|
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:
|
|
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 |
|
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
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
text
|
The unique Retailer SKU of the child product.
This column will only be used if the value of |
|
bundle_quantity
integer
|
The quantity of this component that is included in the bundle. |
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:
The |
|
all_inventory_sync_directions
integer
|
This is the same as the |
|
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:
The |
|
all_inventory_quantity_buffers
integer
|
This is the same as the |
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. |