In the "Import Products" screen, a list of supported column titles will be displayed below the "Paste" box. This list will automatically update whenever custom product or pricing fields are added or removed, or when certain features are enabled/disabled.
Overview of basic column titles:
Product ID
The product ID is the unique database key that identifies the product. The field can contain ASCII characters not including whitespace, up to 191 characters total. Product IDs can be uniquely your own or borrowed from your supplier's product ID. It can also be changed at a later date if desired (see the help article How do I change or update the Product ID for a product?)
Description
The description is the name of the product, up to 256 characters. Non-ASCII Unicode characters are supported, so the name can be in a non-English language, including languages such as Chinese or Japanese.
*For Finale 3D customers. the description is also the recipe by which Finale choreography tools construct a default simulation for the product. Since Finale incorporates language parsing technology to interpret and understand the description, the default simulations are usually a reasonable match if the description is in fact descriptive. If the description is a proper name, such as for a consumer cake, then you will need to add a custom simulation rather than relying on the default. The Finale choreography documentation provides further details on simulations.
Category
The category must be an exact match to one of the product categories set in "Application Settings > Product". The matching is case-sensitive and whitespace sensitive.
Notes
Notes are a description of the product, up to 256 characters Unicode.
Std accounting cost
Std accounting cost functions as the actual cost for each item, written as an integer or floating point number with a period decimal point, no dollar sign or other currency symbols, e.g., "1.2" not "$1.2". Although you may have acquired stock at varying costs from different purchases, this Std accounting cost property of the product is a single number that is considered to apply to all stock of this particular product. Therefore if you change the Std accounting cost of a product, that change applies to all your stock of that product.
Item price
Similar to Std accounting cost, the item price is the price per each item, written as an integer or floating point number with a period decimal point, no dollar sign or other currency symbols, e.g., "1.2" not "$1.2". The actual price at which you sell stock may vary from sale to sale depending on discounts that you may offer, but the base level price used in the calculation to determine the actual selling price is this item price for individual items or the case price (see below) for stock sold in cases. Finale will always respect product pricing as it exists on imported orders.
Case price
Similar to item price, the case price is the price for stock sold in cases (if you are keeping track of cases separately from open stock), written as an integer or floating point number with a period decimal point, no dollar sign or other currency symbol, e.g., "1.2" not "$1.2". The actual price at which you sell stock may vary from sale to sale depending on discounts that you may offer, but the base level price used in the calculation to determine the actual selling price is the item price and case price.
Std packing
The standard packing is a string of the form "36/1" or "12/12/1" or "12/12" or just "72", defining the default packing for cases of this product. The first number in the string identifies the number of items in the case. Since it is possible to keep stock in cases with different packings simultaneously, the actual packing of case stock must be a property of the stock itself rather than a property of a product. That is why this field is called the "standard packing" or "default packing" rather than the actual "packing." The relationship between the standard packing and the actual packing is this: if you specify a case quantity in a order or stock operation but do not specify the specific packing of that case quantity, then the standard packing is filled in by default. The purpose of the standard packing is to make it so you don't have to type in a specific packing all the time, and yet to allow you to type in a specific packing when you need to.
When the standard packing is filled in by default, the result is identical to the result of typing in that same packing string by hand. This result then becomes a property of the stock involved in that order or stock operation, decoupled from the standard packing property of the product. Thus if you later change the standard packing, that change will have no effect on existing stock or transactions.
Std bin ID
The standard bin ID identifies the standard bin, box or bay in which a product is stored inside your warehouse. This can be used to define sub-sublocations or just list the sublocation a product is located in, if your products do not move around in your warehouse. This field can be referenced on reports as well as pushed up to integrations like ShipStation to help with the order fulfillment process. Please note that Std bin field is simply a text field meant for reference purposes, and is not required nor designed for holding stock. Stock is only held in sublocations. (Please reference this help article for more information: How do I set up Locations and Sublocations?)
Status
If you want to deactivate or activate a batch of products, you can import a spreadsheet with just two columns: Product ID an Status. The status fields in the rows should contain the word "Inactive" or "Active".
Manufacturer
The manufacturer field is simply a text field intended for the name of the manufacturer.
*For Finale 3D customers, since transactions in the DSMT reports are grouped by product category and manufacturer, it is important that your manufacturer field values do not have typographical errors. The items in each group must match exactly. Items with the manufacturer "LIDU" will not match "LDU".
Mfg product ID
The manufacturer product ID is the product ID assigned by the manufacturer.
*For Finale 3D customers, if you are using Finale choreography tools, the manufacturer product ID, if set, will identify the manufacturer provided simulation for that product type if it exists, which would be used as the default simulation for the product instead of a simulation constructed based on the description.
Mfg country
The manufacturer country is the country code, e.g. CHN or USA. It must be an exact match to the international standard country codes.
Weight per item
Like Std accounting cost, the weight per item is the weight of each item, written as an integer or floating point number with a period decimal point, no unit of measure, e.g., "0.025" not "0.025kg". The unit of measure is specified separately as the weight unit (see below).
NEQ per item
Like weight per item, the NEQ is the net explosive quantity of each item, written as an integer or floating point number with a period decimal point, no unit of measure, e.g., "0.025" not "0.025kg". The unit of measure is specified separately as the weight unit (see below).
Note: when changing the "Weight unit" through the bulk Products import, the "NEQ per item" field for updated products will get cleared out as a result. It is considered best practice to import the "Weight per unit", "NEQ per item" and "Weight unit" fields all at the same time.
Weight unit
The weight unit is the weight unit of measure, either "kg" or "lb". If weight per it or NEQ per item is supplied but weight unit is left blank, then it is set to "lb" by default. The field is imported case insensitive. The accepted values for import are Kilogram, Gram, Milligram, Pound, Ounce and Grain.
Note: when changing the "Weight unit" through the bulk Products import, the "NEQ per item" field for updated products will get cleared out as a result. It is considered best practice to import the "Weight per unit", "NEQ per item" and "Weight unit" fields all at the same time.
Custom Fields or Pricing Fields you create or add
As you add new custom fields or pricing fields, they will automatically appear in available to be imported list of fields.
Comments
0 comments
Article is closed for comments.