Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Inventory Report / Accounting Tool + Issue with reports
andre jarema

Excellent
August 30, 2015 - 5:47 am
Member Since: October 23, 2013
Forum Posts: 64
sp_UserOfflineSmall Offline

Is there a tool that could give an instant snapshot of the inventory we currently have in our warehouse? Also if this tool would allow to separate the inventory held by Amazon on their warehouse and the stock we have in our warehouse, that would be even better. It could be an accounting tool that does more (and help us with VAT returns)

At the moment, I use dataflow exports and add up the quantities and values via Excell myself. But i am encountering the following issue: some SKUS appear duplicated in the file. Does anyone know why that happens? It’s only the SKU field that appears several times. Sometimes 2, 3 or 4 times. The other fields are blank. For example:

Qty SKU Name att_cost
10 HKL-SHI-SET Heidi Klum Shine Miniature Set: 15ml EDT + S/G 75ml 2.89
HKL-SHI-SET
HKL-SHI-SET
HKL-SHI-SET

Avatar
Jim @ Moogento
Global

Partner
September 29, 2015 - 1:10 am
Member Since: November 7, 2013
Forum Posts: 688
sp_UserOfflineSmall Offline

andre1 said
Is there a tool that could give an instant snapshot of the inventory we currently have in our warehouse?

Hey Andre, stockEasy can do that for you.

Also if this tool would allow to separate the inventory held by Amazon on their warehouse and the stock we have in our warehouse, that would be even better.

How do you keep track of / import Amazon inventory into Magento at the moment?

At the moment, I use dataflow exports and add up the quantities and values via Excell myself.

stockEasy actually keeps a daily record of each sku, cost/price/qty, so you can go back to any date and work out the value of stock. This for sure helps with accounts!

But i am encountering the following issue: some SKUS appear duplicated in the file.

Does the number of duplicates match the number of simple products?

Tbh I’ve never found the reports easy to use (one of the reasons we made stockEasy).

  • pickPack - smarter Magento packing sheets and warehouse picklists
  • shipEasy - process multiple orders with no sweat & get a visual sales overview easily

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5222

Posts: 27488

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606