I am looking for a solution to get my new orders over to my print/post provider without having to manually manipulate a spreadsheet.
I have all my artwork and thumbnail files in Dropbox which have the same SKU's as the garments on Shopify.
However I need to export each order to a CSV, format in such a way that it matches the order management software, and attach the relevant dropbox links before sending it over for print.
I have been looking at Zapier and other order export solutions but is there a really simple way of doing this please?
Solved! Go to the solution
The part that complicates this is you need to attach a link from dropbox that matches the product SKU in Shopify in your export. I understand what you're trying to do here. What if a custom app could store those links and handle your formatted CSV export? We can definitely work out the solution to make things efficient for you and work with your order management software.
Please drop us an email for pricing and more details. Or visit our site: https://achieveapplabs.com
Sam - Lead/Owner
This is an accepted solution.
I believe that Exporteo could handle these requirements. The app transforms orders to a custom format (CSV, JSON, PDF, XML), and sends them over to an external system. I can help you with setting it up. I have an idea how to attach relevant dropbox links.
if you want to take csv or each order in a specific pattern with dropbox link.
i think best option for you is:
step 1)from dropbox api take information and insert in sql database
step 2)from shopify rest api taake information and insert in sql database
step 3)from sql table then you can use sqlcmd for automatically file making process and it will automatically make a csv for you in any folder in your computer.
NOTE: FOR THESE PROCESS YOU NEED
REST API LINK AND AUTH FROM SHOPIFY
REST API AND AUTH FROM DROPBOX
BASH CURL FOR WINDOWS
and these steps are so simple you can use BASH cURL for this process which is so easy. in my opinion it should take maximum 7-8 hours for developing this kind of program which will take information from dropbox and shopify and make csv.
if you need help in developing please write a reply then i will guide you how you can do it. but its so simple you can google it.