[HOW TO] Preparing a Product Import Spreadsheet

Print Friendly and PDF

Your products are the foundation of your company, and the same goes for Skubana. The first question you should ask yourself is, "Do I have a Master SKU?". Your answer may be Yes, No or I don't know. If you answered, I don't know, most likely you don't know and/or are unaware of what a master SKU is. 

A master SKU is the unique value that you give to a product to identify it in-house. If you resell products, you might use the vendor's UPC or product ID. If you private label, you might use the product's UPC or SKU. The ease of creating the product import spreadsheet will come down to how many products you have and how well-documented your products are.

To download a product import spreadsheet, follow the steps below.

1. On the Toolbar, click Products.

2. Click Import/Export, then Import Products.

3. On the Product Import window, click Download the Excel Template for Product Import. Open the Excel spreadsheet and complete the Product Import spreadsheet. You may also download the spreadsheet by clicking here.

Required Fields:

Master SKU

Name 

Brand

Active Column

NOTE: We recommend having a maximum of 4000 products per spreadsheet for maximum efficiency. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.