Product Update Format - Custom Spreadsheet Imports (FTP Upload)

  • Updated

Manage your product data with your own Custom Spreadsheet format!

A custom spreadsheet is an excellent tool for managing your data in DC. We create an automated import process tailored to fit the data structure that best suits your products.

Then, to manage your DC product data, just upload your complete product data list in your custom spreadsheet to our SFTP by following these steps:

Product Update Method(s)

FTP (Upload)

Your complete Custom Spreadsheet must be uploaded to our SFTP by following these steps:

Spreadsheet Upload Requirements

  1. Must follow the Custom Spreadsheet format originally submitted.

  2. 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.

Who does this work best for?

The Custom Spreadsheet format works for any supplier with a custom export of their data. (Custom is a spreadsheet that doesn't come from SAGE or ASI).

The Custom Spreadsheet must include the following minimum required data: 

check.png   Product name

check.png   Product number

check.png   Net pricing

check.png   Retail pricing

check.png   Discount codes

check.png   Product images

check.png   Description OR Bullet Points

 

If Decoration Information is available for your products, please provide the following information:

check.png   Decoration method

check.png   Decoration location

check.png   Decoration charge

check.png   Decoration setup

 

Who does this NOT work for?

The Custom Spreadsheet requires your spreadsheet to be uploaded via SFTP in the same format each time. At first, FTP uploads require some technical skill. Suppliers who aren't comfortable with uploading their data via SFTP or who can't provide updates in the same format each time will need to use another Product Data Update Format to manage their DC product data.

If you have questions whether the Custom 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