How can I identify and export all unsent products?

Shopify Discussion
1

Have you guys found a way to export or identify all of your unsent products? I have a lot of back-ordered items as well as items that are made to order (shipping time takes 8 weeks). I’d like to be able to see what my “unearned revenue” is so I know what money has to come out of my account. I’ve tried exporting my sales segmented by order, but that doesn’t pull my expenses (cost I pay per item).
Any help would be much appreciated!

2

Hi

The sales and product data are stored in separate tables so you won’t be able to use one csv export to get what you need. You could export both tables and then run a macro in excel to calculate what you are after. Some VB/Excel experts should be able to create something like that for you.

We have a consolidated report using Shopify API that we generate for some of our users that uses new unfulfilled orders. You could tweak it to recalculate on all unfulfilled orders and produce columns from products and sales data. This way its constantly updated and generated without the hassle of csv exporting.

Regards

Tom

3

@Robert123456753 I could create a small private app for your store to get this information.

Assuming this is the flow:

  1. Get all past orders that are not archived.

  2. Extract unfulfilled line items.

  3. Get the product information of the line items (cost per product).

  4. Calculate totals, show a list, etc in a csv

If this is something you do regularly, I can make an embedded app in your Shopify admin where you select the dates of orders and have it run the check and export a csv.

If that’s something you’re interested in, send a message with any details to speedboostr.com/contact and ask for Joe. I’ll take a look at the requirements and give a proposal.

4

Hi Tom,

Is this something that you’d be able to develop?
Robert

5

Hey Robert

The system is already there so you can link your Shopify orders and all new orders will be processed. I can then get my team to tweak for anything you need such as total based on retail or cost price. You can then also clear rows as you receive stock from the UI so you have full control over the report. As part of the system we also have a function to display unfulfilled orders and manage multi line orders by allocating stock to them as you receive (not sure if you would require that).

If you want me to help you test it out and see if it would work for you just shoot me an email at tom@channelup.io

Regards

Tom