Use Shopify & EasyCSV Together
How to use EasyCSV to quickly import New Products & Update existing SKUs with supplier or ERP files in your Shopify Store. You can also Create or Export Shopify Orders.
Quick Links:
- How to set up automated Shopify Stock and Price Sync
- How to set up a Shopify import page for creating new Products
- How to import new Products with Shopify Metafields
- How to set up a Shopify import page for updating SKUs from a supplier or ERP file
- How to update Shopify Product and Variant Metafields in bulk
- How to update Shopify Catalog Price Lists for B2B Wholesale in bulk
- How does EasyCSV update available stock for my store?
- How to create Shopify Orders from CSV or XLSX files
- How to create Shopify Orders with B2B/Wholesale Solution custom prices for products from CSV / XLSX Files
- How to bulk update Shopify Orders with Tracking Numbers and more
- Why should I use EasyCSV with Shopify?
- How do I reconnect Shopify to EasyCSV?
- Why is Shopify limited to creating a certain number of new products at once?
- Why is Shopify limited to 5 MB file sizes for product images?
- Can I do imports for more than just Products? Like Inventory, Variants, etc...
How to set up automated Shopify Stock and Price Sync
Click here to add the EasyCSV App to your Shopify Store
How to set up a Shopify import page to create new Products - 4 minutes
Click here to add the EasyCSV App to your Shopify Store
How to import new Products with Shopify Metafields
Click here to add the EasyCSV App to your Shopify Store
How to set up a Shopify import page for updating SKUs from a supplier or ERP file
Click here to add the EasyCSV App to your Shopify Store
- Set up you EasyCSV import page using an example CSV file from the supplier or ERP system.
- Choose the option to "Update existing SKUs"
- Go to Field Mappings once your import pages is created. Choose to column from the spreadsheet that has the SKU. Then choose all the other columns you want to update IF they are different in the spreadsheet file. You don't have to map all fields in Shopify. If you need to set a field on the product or the SKU with an If/Else statment use an EasyCSV Virtual Field.
- You can go to your Import Data Flow (top link on your import page) to add tags on products that you want to Skip updates for. This is great in case you have some key products you maintain. Add a tag like "no_update" to the product listing in Shopify, then tell EasyCSV the tag name you used in Shopify. EasyCSV will skip updating those SKUs.
- You can now do some test imports or a real import and see the mapped fields updated if there are changes.
How to set update Shopify Product and Variant Metafields in bulk
Only available on our Custom Plans starting at $39/mo. - Contact EasyCSV Support if you need this functionality
Click here to add the EasyCSV App to your Shopify Store
- In the Import Flow area of your import page/flow scroll the the bottom to the Shopify options.
- Make sure the action you select is "Update Existing SKUs"
- At the bottom of the Import Flow Shopify Options - click to specify field mappings.
- If you are on the $39/mo plan or above, you will see your metafields at the bottom of the list to map data from your File or Virtual Fields to in Shopify.
How to update Shopify Catalog Price Lists for B2B Wholesale in bulk
Click here to add the EasyCSV App to your Shopify Store
How does EasyCSV update available stock for my store?
EasyCSV has done a lot of testing and stays modern with how we make availble stock / inventory updates. We have designed a solution to help balance making a large number of updates while trying to not make unecessary Shopify API calls. The table below details the scenarios and logic use to update stock values:
# of locations in Shopify | File Size (CSV or XLSX) | How it works |
---|---|---|
1 | Any size | EasyCSV will efficiently check all inventory levels and only queue up stock updates for Shopify if the mapped file value for quantity/invenotry is different from what is in Shopify. |
2 or more | Small files (15,000 rows or less) | EasyCSV will efficiently check all inventory levels and only queue up stock updates for Shopify if the mapped file value for quantity/invenotry is different from what is in Shopify. One EasyCSV import page configuration can be mapped to one location. You will need multiple import pages if you want to sync available stock for multiple locations. |
2 or more | Large files (more than 15,000 rows) | EasyCSV checks as many inventory levels in Shopify as it can but it may be a small percentage of the rows in a large file CSV / XLSX file. The Shopify API limits simply make it take too long to check ALL SKUs in a file. For the SKUs EasyCSV can't check due to API limits with the Shopify API, EasyCSV will simply issue an update request for inventory based on the data in the file. EasyCSV will also help you save on API calls by not making the exact same inventory update API within 24 hours. This check helps you move through large files more efficiently. EasyCSV is mainly built for syncing a small amount of changes every day of the week or every 4 or so hours during the day. We have found this logic to be the best balance of efficiency and accuracy for customers with large volumes of data. We have many mid to large size Shopify stores having a lot of success with this logic. One EasyCSV import page configuration can be mapped to one location. You will need multiple import pages if you want to sync available stock for multiple locations. |
How to create Shopify Orders from CSV or XLSX files
Create Shopify Orders from CSV or XLSX files you receive or you want EasyCSV to grab from FTP, Google Drive, Dropbox, Email, and more!
Click here to add the EasyCSV App to your Shopify Store
How to create Shopify Orders with B2B/Wholesale Solution custom prices for products from CSV / XLSX Files
Only available on our Business Plans and above. Install both the EasyCSV app in your Shopify Store and the B2B/Wholesale Solution App by BSSCommerce in your store.
Click here to add the EasyCSV App to your Shopify Store
How to bulk update Shopify Orders with Tracking Numbers and more
Click here to add the EasyCSV App to your Shopify Store
Why should I use EasyCSV with Shopify?
EasyCSV makes it easy for you to receive a CSV/spreadsheet from your product supplier or if you like to write out your new products via spreadsheets firsts then quickly import regularly. No more mapping which column goes to what field in Shopify every time you get a new file. Just set up an import page, drop the file in (or email it to a custom email you get), watch the new products be created in Shopify!
How does the Create Products import work?
EasyCSV has made an importer that accounts for the slowness of the Shopify API. The importer will first create all products from your spreadsheet file without images. Then a process runs to upload all the images. Why? In short, the SHopify API is really slow when adding images to a product. To creat a product with no images takes less than a second. To create a product with 1-5 images usually takes 4-8 seconds depending on the images sizes. Once the products are created in your store you should see images fill in slowly. Keep in mind it may take a little bit (Example: if you import 100 new products, that could take up to 800 seconds / 13 minutes for all images to appear on every product).
What if an image never appears on the product listing? Usually this means Shopify could not download the image from the Image URL that was submitted from the file. The image URL could have been wrong, invalid, or not public. If you notice this please look at the image urls in a web browser and attempt to upload them yourself. If you are able to see the images in the browser, and can upload the image yourself to shopify please reach out to EasyCSV support and we can help troubleshoot your imports.
How do I re-connect Shopify to EasyCSV?
Option 1
- Be logged into EasyCSV.
- In your Shopify Store admin, click "Apps" in the left navigation.
- Search for EasyCSV
- Click on EasyCSV and you will see a page with an "Update" button in the upper-right.
- Click the "Update" button and you will see a progress bar. Let it finish and everything is all set.
- If you have any issues, try Option 2 below or reach out to EasyCSV support via chat or email.
Option 2
- In your Shopify Store admin, click "Apps" in the left navigation. Delete the EasyCSV app. You can also find this page by navigating to https://{ your store }.myshopify.com/admin/apps
- Be logged into EasyCSV and then click here: Add EasyCSV to Shopify
- If you have any issues, reach out to EasyCSV support via chat or email.
Why is Shopify limited to a certain number when creating new products?
EasyCSV would love to help you import many thousands of new products for your Shopify store. However, Shopify has not optimized their API to be fast. This limit does not exist when needing to update SKUs in SHopify. Only when creating net new products in your store from an import.
Shopify typically takes between 1-8 seconds to create one new Product with a couple images via their API. New product creation via the API takes longer with multiple images (especially large file sizes).
Let's take an average speed of 5 seconds of processing per row by Shopify. Attempting to import a thousand records or more might not be a great fit – this is because processing 3,000 records would take about 120 minutes to run.
If you want to import more than 2000 records at once for your Shopify store please contact EasyCSV support. You can also import once. Wait for the records to be created in Shopify. Then import the same file again. EasyCSV will skip already created products and only make new ones.
Why is Shopify limited to 5 MB file sizes for product images?
Shopify has not optimized their API to be fast. In order for your imports to process is a respectable amount of time EasyCSV limits image file sizes for images to be 5 MB or less. Please optimize your images when saving them. If you need to be able to import larger images please contact support@easycsv.io and we will see what we can do for you.
Can I do imports for more than just Products? Like Inventory, Variants, Orders, etc...
Yes! Just email support@easycsv.io, tell us your use case, and will help you do imports for other Shopify objects.