Hi there,
I am trying to export my past orders from my wordpress/woocommerce website and import them into my unpublished shopify website.
I’ve tried a few apps and it eventually fails every time. WP all import and it failed at the woocommerce end. I’ve linked both my shops into metorik but can’t see how to copy the orders over. I do have a csv of all my orders but can’t see how I can import them into shopify…
Any advice on an easy method? Thank you
Hello, and welcome to the Shopify Community. I’m sorry that your attempts at transferring your data have been unsuccessful. You wrote about using apps to get your Woocommerce orders in your Shopify store, but have you tried following the guides that Shopify provides for achieving this manually, please follow these two links to get a better idea of the process:
Keep in mind that your .csv files have to conform to the formats outlined by these guides, also make sure that your Internet connection isn’t getting in the way of the transfers, maybe split your files into chunks and only send some at a time to ensure that the process isn’t impacted by the volume of data being transfered.
If this doesn’t help, you might need to allow access to your store to a Shopify Partner that will help you with the process. Hope this at least leads you on the right track.
Thank you - I will give it a try and leave feedback once I’ve come to a conclusion.
I’m trying to do import historical orders from Bigcommerce into Shopify. In the link you included it says for bulk migration of orders to use the Orders API. It looks like you can only send 40 requests per minute and the order create POST request can only accept one order per request. For the number of orders I am trying to migrate that would take around 375 hours. Am I understanding that correctly?
https://shopify.dev/docs/api/admin-rest#rate_limits
https://shopify.dev/docs/api/admin-rest/2025-01/resources/order
It seems that you are correct for the methodology you are describing, and 375 hours is roughly half a month; assuming no issue, that’s quite the delay. However, the Orders API you are linking to is a legacy API that is deprecated, if you want more throughput you should use the new GraphQL API (https://shopify.dev/docs/api/admin-graphql/latest), the rate limit for this API is much more permissive(https://shopify.dev/docs/api/usage/rate-limits), although it would be much more difficult to calculate how much it is in practice, in theory with a maximum cost of 100 points per second, and mutations costing 10 points, you should be able to get 10 orders in per second, so 600 orders per minute, which is I believe, more orders than you have. But this implies you know how to code or know someone who can do it for you, otherwise you should contact a migration expert or use an app.
I have been using the GraphQL API but unfortunately there seems to be other resource based limits when creating orders that is not clearly documented. Despite having lots of available points, as indicated by the GraphQL response throttleStatus, it often returns with a [{ field: null, message: "Too many attempts. Please try again later" }] user error. I have a backoff and retry in place for handling these errors which is resulting in about 5 orders per minute. That is why I was exploring if using the Orders API, while deprecated, might give me a higher throughput. I’m really curious how migration apps are able to achieve higher throughput on non-Shopify Plus stores, if that is possible, since I’m using the same APIs the apps would.
Sadly, I don’t have first hand experience with migration, and your explaination shows that there definitely is something going wrong, but I don’t have expertise to tell you what.
How many inputs are you sending though? You can only send an array of 250 items(orders in your case), even though it won’t be processed immediately. Maybe it really is related to timing, and you’ll have to try at a later time to avoid the throttling. I don’t have much else to add unless I go and spend some time building an app to see how it works in practice and not in theory. Sorry for the underwhelming response. I sincerely hope you’ll figure it out, in which case, don’t hesitate to post back about it, so that it may help someone else in the future.
After searching a bit, I found this link to a previous community post in the dev branch:
https://community.shopify.dev/t/ordercreate-mutation-error-after-5-imports/6855
The throttle you are experiencing is related to using a development store. So that is likely what is happening here, a merchant store wouldn’t have such limits, it’s just badly documented.