Product Update Format - Advanced Spreadsheet

  • Updated

Manage your product data with DistributorCentral's comprehensive, all-in-one product data spreadsheet format!

Product Update Method(s)

The Advanced Spreadsheet must be uploaded to the Bulk Product Manager in your DC account.

Spreadsheet Upload Requirements

  1. Must follow the Advanced Spreadsheet format.

  2. Must export a new spreadsheet from DistributorCentral before applying and uploading product data updates to DC.
    This helps to avoid over writing current data that is not reflected in older spreadsheets.

  3. Must include a complete list of your products every time a spreadsheet is uploaded
    Because of how our importer functions, if you don’t include all your products in the spreadsheet you upload, any products that are not listed will be removed from our database.

Data Definitions

Find data definitions and examples in the "Data Definition" sheet of your Advanced Spreadsheet file. 
Learn how to Export your product data --> 

What type of products does this work best for?

Suppliers who have complex products are a good fit for the Advanced Spreadsheet!

If you offer more customization options than just Product Colors, Apparel Sizes, and Decoration Information then this spreadsheet is the Product Data Update Format for you.

All of the following customization options are compatible with the Advanced Spreadsheet:

check.png   Product colors

check.png   Decorations setup & run charges

check.png   Apparel colors

check.png   Apparel size up charges

check.png   Proof charges

check.png   Artwork charge

check.png   3rd party billing charge

check.png   Product color up charge

 

What type of products does this NOT work with it?

The Advanced Spreadsheet is a comprehensive format and can handle most any product type. however, if you have thousands of products in DC you may find this spreadsheet to be overwhelming to update.

If you have questions whether the Advanced Spreadsheet is the best solution for you, please contact the DC Product Team.


What if you need to make a change to my Product Data Update Format?

If you'd like to change your Product Data Update Format, please contact the DC Product Team. Our data experts will review your needs and alert you to any major data structure changes that may result from the transition to a new Product Data Update Format. Then, we'll work with you to change the file format you use to update your DC products.  

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request