Turn emailed spreadsheets and POs into Shopify orders

Shopify can import products, customers, inventory and gift cards. It cannot import orders. There is no button, and no plan unlocks one.

The routes that do work fall into three shapes, and the right one depends on a question about your customers rather than your catalogue: who is willing to do the typing?

• Your staff uploads the file. Cheapest, from about $8/month. The customer changes nothing. You still open their spreadsheet and reshape it into the importer's format.
• The customer builds their own order. A storefront form where they paste a list of item codes or upload a file. Around $15–45/month. Excellent when they will use it — and useless when they won't.
• Software reads the email for you. Newer, AI-based, from about $100/month, with line limits worth checking. Removes the typing entirely rather than moving it.

Below: what each one actually does, the trap in the free native route that nobody warns you about, and where this stops being solvable off the shelf.

What this costs the people doing it

The clearest description of the problem came from a small brand in June 2026:

Small brand here, we wholesale to 40 stockers/vendors. Most just text or WhatsApp/slack/telegram etc. their reorders ("hey can we get the usual plus 6 of the lavender"). Every morning I retype each one into our current order system by hand. I really don't want to make them log into a wholesale portal — half of them won't use it anyway. Is there any app or trick that turns those texts into a Shopify orders automatically (matching my SKUs + wholesale prices), or is manual the only way?

— stewyapp, 30 June 2026

Note the second sentence, because it is the one that kills the most-recommended solution: half of them won't use it anyway. Wholesale buyers order the way they have always ordered.

The volumes get large. A German wholesaler in 2021 described customers ordering up to 1,000 line items at a time, and pointed out — reasonably — that a normal shop front cannot really present that. A UK sign manufacturer running about a million item codes says many of its orders arrive as emailed PDF purchase orders. A US distributor put a number on the years rather than the minutes: "We have been manually entering B2B orders into shopify for 6 years."

And it is not only slow. An Austrian-facing wholesaler found that hand-keyed orders came out with the wrong VAT treatment on the invoice, because the manual path did not carry the tax status the customer was entitled to. That is the kind of error that is expensive precisely because nobody notices it for months.

The free native route, and the trap in it

The standard advice — from Shopify's own community and from most articles — is to use draft orders. You create the order yourself in the admin, so the customer needs no login and no portal. For a handful of orders a week that is genuinely the right answer, and it costs nothing.

Two things about it are worth knowing before you build a process around it.

Searching by item code in the admin is poor. A wholesaler summed it up while explaining why their customers paste code lists instead: "as we all know Shopify isn't very good at searching by SKU!" If your catalogue is large and your customer's file is a list of codes, you will feel this on every line.

And the customer gets emailed whether you want it or not. This is the part that surprises people. A Shopify staff member confirmed it in January 2021:

When you mark an order as paid it's treated very much as though an order was transacted through your online store. As part of that process, an order confirmation email must be sent and cannot be disabled at this time.

— Olivia, Shopify staff, 26 January 2021

The workaround she offered was to leave the customer's email address off the record entirely — which of course also removes your ability to email them anything on purpose. Merchants have been asking for a simple checkbox ever since. One in 2021: "adding just a checkmark allowing us not to notify customer when an order is created." Another, three years later: "After 3 years, can Shopify just add this option??" The thread runs from January 2021 into 2025 with new people still arriving.

For wholesale this matters more than it sounds. One merchant supplying schools described the result: the customer receives a tax invoice, then later a second one with a different number when payment lands, and "I then have to email and tell them to ignore that invoice. It's very cumbersome and very unprofessional."

Need drafts created without emailing the customer? See what a rule you control looks like →

Route 1 — Your staff uploads the file

The lowest-cost real fix. You take the customer's spreadsheet, reshape it into the importer's columns, and it becomes a draft order or an order in your admin. Your customers change nothing about how they order.

Typical pricing runs from about $8/month at the low end to roughly $15/month for admin-side tools that also let you paste a list of item codes, with credit-based options around $35 per 250 imports for occasional bulk work.

What decides whether this works for you is the reshaping. Every customer's spreadsheet has its own column order, its own header names, and its own idea of what an item code is. If you have five wholesale customers who each send a different layout, someone is still doing skilled work every morning — less than retyping, but not nothing.

Check the item-code matching specifically. Some importers match on your item code or barcode; others need internal Shopify identifiers, which your customer's file will never contain. This is the single most common reason an import that looked simple turns into an afternoon. Reviews of these tools contain plenty of both experiences — one merchant called an importer "an absolute gamechanger", another spent "2 hours trying to import" and concluded the supplied template was useless.

Route 2 — The customer builds their own order

A form on your storefront where a logged-in wholesale customer pastes a list of item codes and quantities, or uploads their file, and it fills their cart. Roughly $20–45/month.

Where this works, it works better than anything else, because the person who already knows the order enters it. One merchant reported that after adding a paste-a-list form, about 90% of their wholesale customers used it — and specifically the paste option rather than file upload. Another: "We have customers who place regular POs on our B2B store and now they can instantly build a cart by pasting SKUs into the form."

The condition is that your customers will log in. That is a real question about your relationship with them, not a technical one. The merchant with 40 stockists ordering by text was blunt that half of his would not, and he is not unusual — the buyers who order by WhatsApp do it because it takes them eight seconds.

Worth knowing about Shopify's own B2B features here: there is something called a quick order list, and its name promises more than it delivers. It is a section on a product page showing that one product's variants in a table. It is not a paste-a-code-list form and it does not accept files. Shopify's B2B features are available on the standard plans at no extra fee, so it costs nothing to look — just do not plan around the name.

Half your buyers will not use a portal? The order still has to get in somehow — see the third way →

Route 3 — Software reads the email for you

The newest category, and the only one that removes the typing rather than relocating it. You forward the customer's email; the attachment — PDF, spreadsheet, sometimes a photo — is read automatically and turned into a draft order matched to that customer.

Merchants using it are enthusiastic in a way that is unusual for this category. A distributor after six years of manual entry: a 100-plus line order in under four minutes. Others describe the time "cut in half". One said simply: "I have been waiting for someone to create an app like this for years."

The pricing is a different order of magnitude: free for a handful of orders, then roughly $100–250/month, sometimes charged per order processed. At high wholesale volume that can still be cheap. At ten orders a month it is not.

⚠️ Check the line limit before you commit. At least one tool in this category caps at 50 lines per order. If your customers send 200-line reorders — and the merchants in these threads routinely do — you will hit that wall on your largest and most valuable orders, which are exactly the ones you bought the tool for.

What Shopify has actually built, and where it stopped

This is worth stating plainly because it explains why the gap has lasted six years and why no plan upgrade closes it.

Shopify does have file upload that turns a list of item codes and quantities into a document. It exists for purchase orders — the ones you send your suppliers — where you can bulk import products from a file. It was also added for inventory transfers in July 2025.

So the exact interface has been built twice. Never for customer orders.

A few other things that are true and rarely written down:

• Automation cannot rescue this. Shopify's built-in automation tool can create a draft order. It has no way to read a file — no spreadsheet, no email attachment, nothing. It can act on your order, but it cannot see it.
• Item codes are not what the system uses. Creating an order through the interface requires internal product identifiers, and there is no item-code field. Anything that imports from a customer's file has to look up every line first. That is why matching quality varies so much between tools, and why it is the thing to test.
• The line limit is documented twice, differently. One Shopify page says a draft order fails above 200 lines; a June 2025 developer note raised the limit to 499. Both are current. We are not going to guess which governs your store — but if you are near either number, test with a real order before you trust it.

Which route is yours

That last row is the one worth being honest about. Getting the lines in is a solved problem with several good tools at several price points. Getting the lines in with the right wholesale price, the right tax treatment, the right payment terms and the customer's own purchase-order number attached is where merchants in these threads keep stalling — the Austrian VAT problem and the schools' purchase-order process are both that shape, and neither was solved by an importer.

Recognise your store in that last row? See what the rule looks like when it is yours →

What it is costing you now

Two numbers, both of which you can work out this week.

Time: orders retyped per week × minutes each. The merchants above describe "every morning" and "six years"; one reported going from a long manual slog to under four minutes on a 100-line order. If two people spend an hour a day on this, that is a part-time salary.

Errors: how often does a hand-keyed order go out with the wrong quantity, the wrong price, or the wrong tax? Each one costs a credit note, a phone call, and some trust. Nobody in these threads put a percentage on it, so we will not invent one — but the Austrian VAT case is the reminder that the expensive errors are the quiet ones.

Then weigh those against the routes above. For many stores the honest answer is a $8–20/month tool and an afternoon of setup.

When none of the three fits

Every route above assumes your problem is moving lines into Shopify. For a lot of wholesalers it is, and one of those tools will solve it — buy it and stop reading.

Where it stops fitting is when the order carries rules that are yours. Customer-specific pricing that is not a simple percentage. Tax treatment that depends on where the buyer is registered. Payment terms that decide whether it becomes a draft or an invoice. A purchase-order number that has to land in a specific field because your accounting system reconciles against it. Item codes that are your customer's codes and not yours, so each line needs translating before it can be matched at all.

Those are the cases these threads never resolve, because they are not the same problem for any two merchants.

That is what Shopivibe is for. You describe the intake in plain language — "read the emailed spreadsheet, map their item codes to mine, apply that customer's wholesale price list, attach their PO number, and create a draft without emailing them" — and you get a real Shopify app that does it. Most are working in under five minutes.

Tell Shopivibe what you want your store to do — "read the emailed spreadsheet, map their item codes to mine, apply that customer’s price list, attach their PO number, and create a draft without emailing them" — and it works out how, builds it, and checks it against your own store's data before anything goes live. You see in your Shopify admin, in plain language, what is switched on and what it has done. It stays looked after; there is nothing for you to run.

Early access is open now, and the $49 plan is free for the whole of it.

The comparison, straight: if your files are consistent and your pricing is simple, an $8 tool will do it. Buy the tool.

Where the arithmetic changes is that wholesale is never one problem. The order intake is followed by pricing tiers, then credit limits, then a reorder history your buyers can see, then purchase-order approvals. Each of those normally arrives as another subscription with its own settings screen. Here they are layers of the same app, added by chat — so the second one costs no new subscription, and the pieces know about each other, which four separate tools never will.

On plan requirements, honestly: we try to build so that a feature does not need a plan upgrade, and usually that is possible. Some outcomes genuinely depend on something Shopify gates, and we will not promise otherwise. You will see which one your case needs while building it, not after paying.