Item numbers removed from sales emails - how do you manage inventory?

[b_rudge]

So I've been using a little program my partner coded for me which scans the ebay sale confirmation email to look for the item number of said sold item, and then logs it off in a google sheets doc. Google sheets doc contains all the info on the item such as the title, price / date sold, and which box the item is stored in - and the box in which it is stored would be delivered to me in a separate email. This was great for tax return purposes too as everything was logged by sales date and price sold etc. Worked like a dream until... they stopped putting item numbers in the emails a few days ago.

So, unless anyone knows if the item numbers will be making a come back in the sale confirmation emails - my question is -

How do you manage your inventory? Any ideas gladly welcomed. 

Thank you

[jlovie]

I cut & paste and search in a huge spreadsheet I've been using for over 20 years.

Works at my small scale of mostly individual items, wouldn't work at a larger scale.

(It doesn't even work too well for me for multiples of an item!)

The removal of item numbers is a pain for me and adds more clicks to do anything.

I also filter emails into folders and eBay's constant reformatting of them causes more wasted time for me.

[liz_and_warren]

I download the orders report from seller hub. Contains the custom label field which I use for my inventory and the item number you use.

You get a csv file that imports straight into excel. Straightforward to code from there.

[moldosgifts]

Get yourself a free programme called Adminsoft Accounts, Free Accounting Software

It has an inbuilt stock system keep stabs on your stock

Use SKU for your stock

Example on mine P072 is a patch number 72 i have a tock number P072 on adminoft simple as that.

You can just use that stock system or use the full accounts it totally free.

Can also do the tax digital if you require.

[jonat_broad]

If your partner does coding - they could look to actually work with the ebay APIs or downloadable reports which is what our business does.

Alternatively - based on what you are currently doing - look at Zapier. its a middle man tool but it definitely has an option to take ebay orders and create spreadsheet rows automatically in a Google Sheet.

[b_rudge]

These are great ideas - thank you everyone!