Facebook Linkedin-in Twitter Youtube
Search
SellerEngine
  • Products
    • Profit Bandit
    • Sellery
    • Buy Box Buddy
    • SellerEngine Plus
  • Services
  • Resources
    • Start Selling With Amazon
    • Blog
    • Digital Library
    • Infographics
  • Support
    • Help Docs
    • Help Videos
  • About Us
    • Contact Us
    • Careers
  • Product Sign In
    • Profit Bandit
    • Sellery
    • BuyBoxBuddy
    • SellerEngine Plus
  • Products
    • Profit Bandit
    • Sellery
    • Buy Box Buddy
    • SellerEngine Plus
  • Services
  • Resources
    • Start Selling With Amazon
    • Blog
    • Digital Library
    • Infographics
  • Support
    • Help Docs
    • Help Videos
  • About Us
    • Contact Us
    • Careers
  • Product Sign In
    • Profit Bandit
    • Sellery
    • BuyBoxBuddy
    • SellerEngine Plus

Inventory cost file uploads in Sellery – the right way

  • August 24, 2015
Reading time: 2 minutes

Looking for a solution

 

The first step to maximizing your Amazon sales is to optimize inventory cost file uploads. For any upload to be successful, the data needs to be compatible, consistent and convenient. Our quick and easy walk-through will show you how to leverage every opportunity you have of listing every last one of your products on Amazon for maximum visibility and reach.

To watch our short and sweet Sellery video walk-through, please carry on reading.

 

 

Confused Characters

Earlier in this series, we’ve discussed the benefits of real-time repricing, how smartlists can improve sales ranks, and we’ve also revealed some tips to help you gain a competitive edge with Sellery. One issue we’d like to turn to now is that of incomplete inventory cost file uploads.

We’ve all been through it. We rely on Excel to open an exported inventory cost file, and after we make our changes to the file, we naturally expect Sellery to be able to recognize those changes and accept them, since it was Sellery who created the export file in the first place. But because Excel mistakes SKUs for numbers, it may remove some of the 0s in the SKU column. Any SKU that starts with a 0 will become incomplete, since Excel will remove it by default, because of the default formatting.

Then, when Sellery takes over and starts to process the inventory cost file, it doesn’t recognize these incomplete SKUs, and it sees them as new. It will, therefore, remember these specific SKUs for future reference, and only change the Cost field value for them when they are imported again.

 

Step-by-Step Solution

The solution is so straight-forward, you’ll be wondering why you hadn’t thought of it yourself. After you export a file from Sellery, don’t open it immediately. If you do, Excel will remove any existing 0s from the beginning of the SKU values. You will have to import the data in a new excel file, instead. Here’s what you have to do:

 

  • open a brand new excel file
  • go to the Data tab and find the option ‘From Text’
  • search for the file you need to import and click ‘Import’
  • choose ‘Delimited’ and hit Next
  • select the delimiter and hit Next
  • select the SKU column, and pick ‘Text’ under “Column Data Format”
  • import the data into the existing spreadsheet

 

 

We hope you’ve enjoyed watching the video tutorial, and that our simple step-by-step instructions have helped you solve the problem. For further support and guidance, please contact us here, and we’ll be happy to set the wheels in motion for you.

Daniela Sellery Expert

 

Every problem has a corresponding solution. Don’t stop until you find it!

Daniela is our Sellery expert, if you have a problem she can help you find a solution.

Related Posts

Prime Day 2025

Prime Day 2025: Boost Sales with These 5 Seller Tips

May 7, 2025
Read More »

Export Central: Amazon’s Solution for Cross-Border Selling

January 23, 2025
Read More »

How to Generate Product Reviews and Enhance Seller Feedback

January 16, 2025
Read More »
  • Posted in: Seller Help, SellerEngine, Sellery

Tweet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search The Blog
Subscribe to the sellerEngine Blog
Sign Up
Top 70 Ecommerce Blogs
Fit Small Business
Handle @SellerEngine
At Facebook Instagram Linkedin-in Twitter Youtube
  • Terms of Service
  • Privacy Policy
  • About Us
  • Contact
  • Terms of Service
  • Privacy Policy
  • About Us
  • Contact
© Copyright 2025 SellerEngine