Hi! I have an online vintage store so pretty much everything I sell has it's own product page as we never really get duplicates.
Anyway, I'm doing my taxes for last year (yes, they are really overdue) and my accountant wants me to give an estimate of my stock levels at the beginning and end of that year.
Is there a way that I can put in a date and it will give me a stock list? In my full time job I can just select a date range to see the stock on hand at that time but it uses a custom online store set up and not Shopify, and is a much more comprehensive set up.
Alternatively, how can I see when an individual product was published?
Jason here from Shopify Support.
Since you've mentioned in your post that the information is going to be used for tax purposes, I want to introduce you to Shopify Analytics. Though the data may not directly reflect on the inventory level from the beginning of 2018 to the end, there're numbers that may be equally useful for your accountant.
For going over your online sales by each order in 2018:
For a general sales report in 2018:
If for any reason the data isn't enough for your accountant, I recommend you to try out an app called DeepMine. It offers more advanced reports and has a 60-day free trial period. Feel free to use the app and remove it before the trial day ends to avoid the app charges.
I hope this information helps, however, should you have any questions, please don't hesitate to reply back here and I'd be happy to help out!
All the best,
Julie here from Shopify Support. Jason is no longer able to follow this thread, so I'll be happy to further assist.
At the moment, there is no way to view the date each product was created or published directly in the Shopify Admin. However, there is a neat little hack that will allow you to get this data. If you add /products.json to the end of your store URL, this will give you an array of all products in your store, along with the metadata for when each product was made available. For example, this would look something like example-store.myshopify.com/products.json.
The Store Activity section of your Admin will also give you a breakdown of all the activity in your online store, including when products were published. This is typically located in the righthand sidebar of your Admin. If you're finding the .json method difficult to navigate, then this would be a good workaround.
Alternatively, there is an app called Xporter Data Export Tool I recommend checking out. This app will allow you to view a report that displays the date each product was created. It also includes a free trial, so you can see if it will suit your needs. If you ever need any assistance in getting this report through the app, the developers also have Live Chat, which you can access directly on their FAQ page.
I hope this helps! If you have any more questions, please feel free to respond here and I can further assist.
Thanks for reaching out. Currently, to view the date that each product was created or published, you'll just need to follow the instructions outlined above. That being said, I do know that this is a feature that our developers are currently looking into. Feel free to keep an eye on our Shopify Changelog, where we routinely announce new platform features as they are released.
Hey, @bij! Thanks for reaching out.
At the moment, you'll still need to use either the Xporter Data Export Tool app or the .json method mentioned above to view the date each product was created. While I don't have any updates on whether this feature will be introduced in the near future, I recommend keeping a close eye on our Changelog.
That being said, we have recently introduced advanced product sorting in the Products section of your admin, which you might find useful! This will allow you to sort your products by when they were created (Oldest first, or Newest first). To do this, you'll just need to select the Sort option in Products > All products. Here's what that looks like:
I appreciate you joining in on the conversation and I can definitely understand the need for this feature, so I'll be adding your name to the feature request list for our developers.