Preparing a Listing SKU Spreadsheet

Print Friendly and PDF

The pain point that multi-marketplace sellers have is keeping real-time inventory cross channel. When you sell an item on Amazon, it doesn't communicate to eBay to deduct the sold inventory from its count.

Skubana can automate that process for you. However, to get to that process, you must create a relationship between your listing SKUs on marketplaces and your master SKU within Skubana.

NOTE: The listing SKU spreadsheet cannot be imported until the sales channels are linked. However, it is recommended to complete your products, listing SKUs, and settings (aside from the sales channel portion of settings) first before connecting your sales channels.

To Upload Listing SKUs via Product Import Spreadsheet

1. On the Toolbar,  click Products.
2. On the Products page, click Import/Export, then Import Listing SKUs.

3. On the Listing SKU Import window, click Download the Excel Template for Listing SKU Import.

Note: Each sales channel, including your manual channels, if any, requires its own listing SKU spreadsheet.

See the table below for help in entering information on the template.

Master SKU Listing SKU Push Inventory to Channel? Active

The master SKU used to create the product

Listing SKU from your marketplace

TRUE: For all listing SKUs, except Amazon FBA listing SKUs.

FALSE: For all Amazon FBA Listing SKUs. It is not required  to push inventory levels for FBA listings as the whole purpose is for Amazon to keep your inventory real-time.

TRUE: Active listing SKUs

FALSE: No longer active listing SKUs


4. Once you are done preparing the listing SKU spreadsheet, go back to the Listing SKU Import window, select the sales channel to which you will add the listing SKUs, select the previously-filled up Excel template from your computer, then indicate whether you want the file to update information on existing SKUs. If you are adding your listing SKUs for the channel for the first time, just leave the default setting as-is. Otherwise, indicate whether you want to update the listing SKUs or not.

NOTE: eBay orders will not pull into Skubana unless they have a custom label. Make sure your account is subscribed to the eBay Selling Manager, a free option that allows you to compile and download business analytics files directly off eBay.

5. Click Continue to start the upload process. Wait for the upload to finish, then check the Orders page to see if Skubana properly uploaded your listing SKUs.

NOTE: Click the master SKU number to open the master SKU record, then click the Listing SKUs tab, to view the listing SKUs attached to the master SKU.

See the table below for guidance on how to pull your listing SKUs from your sales channels.

Marketplace Listing SKU Steps to Pull Your Listing SKUs
   Seller SKU 1. Inventory → Inventory Report
2. Select Report Type: Active Listings Report
3. Download → Open the file with Excel
4. Match Column D named “seller-sku” to your Master SKUs
  Seller SKU 

1. Inventory → Inventory Report
2. Select Report Type: Amazon-fulfilled Inventory Report
3. Download → Open the file with Excel
4. Give these Seller SKU a ‘FALSE’ Push Inventory in completed Amazon Listing SKU spreadsheet from the instructions above

  Custom Label 

1. My eBay > File Exchange → Create a Download Request
2. Listing and record: Active → Download Format: Standard → Date Range: All active listings > Enter email address →Save
3. Completed Downloads → Download (Compressed)
4. Match Column B named Custom Label to your Master SKUs

 

Product ID 

1. Product → Product MGMT → Download Catalog
2. Select Column A named “Item ID”, Find the symbol ‘ and Replace with a blank
3. Match the Item ID to your Master SKUs

  Seller Part # 

1. Manage Items → Item List
2a. Less than 1000 products, click the to download your item list
2b. More than 1000 products, email datafeeds@newegg.com for your full item list
3. Match Seller Part # to your Master SKUs  

 

Product ID

or

Rakuten.com Shopping SKU 

1. Manage Products → Download listings
2. Version 3 Type File → Request Export Download
3. Click ListingDownload.zip → Open the zip file
4. Match Column B named Product ID to your Master SKUs

 SKU

1. System → Import/Export → Export
2. Entity Type: Products → Export File Format: CSV
3. Check unnecessary attributes to exclude from file → Continue
4. Match the Column named sku to your Master SKUs

 

Product Code

or

SKU 

1. Products → Product Export
2. Select your export template → Export my to a CSV file
3. Download my file
4. Match Column E named “Product Code/SKU” to your Master SKUs

  Variant SKU 

1. Admin > Products → Product List → Export
2. Export Products: All products > Export Your Products as a: CSV for Excel
3. Export Products → Check your email for the file
4. Match Column N named “Variant SKU” to your Master SKUs

Manual Sales Channel Master SKU   Best Practice: make your Listing SKUs for manual sales channel(s) equal to your Master SKUs. 
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.