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

 

You may want to download the attached products-example.xlsx file below to preview a completed spreadsheet.

Field

Description

Example

Required?

Master SKU

The unique value used to identify a product in-house

1044568

Yes

100 Max Character

Virtual SKU

The unique variation value given to all related products. The virtual SKU cannot be a value that has been previously used as a master SKU. You must have attributes when using a virtual SKU. 

T-shirt

No

100 Max Character

Name

The title of the product

Bedazzled T-Shirt

Yes
100 Max Character

UPC

The universal product code used for barcode scanning

00001044568

No

30 Max Character

Attribute Group

The varying feature(s) for the individual master SKU

Size{Small}Color{Blue}

No

Description

 The description of the product

A bedazzled Skubana t-shirt. 

No

500 Max Character

Image URLs

The URL for the product 

http://www.skubana.com/
example.png

No

Brand

 The brand of the product

Skubana

Yes

Categories

 The category of the product used to quickly filter search queries

Clothing|T-shirt|Women 

No

Labels

 Labels used for search queries and orderbots

Dropship 

No

M.A.P.

 The minimum advertised price

$19.95 

No 

Shipping Cost

 The total shipping cost for the item

$4.99 

No 

Pounds...

The shipping weight in pounds

1

No 

...plus Ounces

Any additional shipping weight in ounces.

2

No 

Height (in.)

 Height of the packaging

No 

Width (in.)

Weight of the packaging

No 

Length (in.)

Length of the packaging

No 

Allow Backorders

Does the marketplace allow backorder orders?

False

No 

Hazmat

 Is the product hazmat?

False

No 

Ships in Own Box

Does this product ship in its own box (usually for oversized boxes)? 

False 

No 

Active

Is this product active?

True

Yes 

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.