Country of Origin CSV

Solved
Furqan_Hameed
Tourist
8 0 0

Hi,

Is it possible to Add Country of origin in CSV file to upload on my store in bulk?

0 Likes
Helen
Shopify Staff
Shopify Staff
887 93 139

Hi, @Furqan_Hameed

 

I’m Helen from Shopify Support. Thanks for your question.

 

A product CSV must follow the format here. The only additional column that can be added that won’t break the format is for a Collection.

 

Therefore, I recommend using the Bulk Editor to most efficiently change or add in a country of origin to your products. To access the Bulk Editor:

 

  • Go to Products from your Shopify admin
  • Select the products that you would like to edit using the checkboxes to the left of each product
  • Click ‘Edit Products’ at the top of your product list
  • Click on the ‘Add Fields’ drop down menu and select ‘Country of origin’. It looks like this:

 

23-35-se2so-0wp0h

 

 

Are you shipping your own products? Or are you dropshipping?

Helen | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

0 Likes
MHShop
New Member
1 0 0

This bulk editor does not let you bulk edit. I still have to manually switch each product. I have over 100. Is there no other way? Shouldn't the default shipping automatically assign products to my one and only ship from location?

0 Likes
Furqan_Hameed
Tourist
8 0 0

@Helen wrote:

Hi, @Furqan_Hameed

 

I’m Helen from Shopify Support. Thanks for your question.

 

A product CSV must follow the format here. The only additional column that can be added that won’t break the format is for a Collection.

 

Therefore, I recommend using the Bulk Editor to most efficiently change or add in a country of origin to your products. To access the Bulk Editor:

 

  • Go to Products from your Shopify admin
  • Select the products that you would like to edit using the checkboxes to the left of each product
  • Click ‘Edit Products’ at the top of your product list
  • Click on the ‘Add Fields’ drop down menu and select ‘Country of origin’. It looks like this:

 

23-35-se2so-0wp0h

 

 

Are you shipping your own products? Or are you dropshipping?


Bulk Editor is too Slow, we have like 40k+ listings and we can only edit 250 in one go so it will take too much of our time 

 

and we ship our own products

0 Likes
Helen
Shopify Staff
Shopify Staff
887 93 139

Hi, @Furqan_Hameed  and @MHShop

 

I completely understand that large product lists can be very time consuming when using the built-in Bulk Editor. In this case, there are some third party apps within our App Store that can help you accomplish the task more quickly. 

 

I recommend Bulk Edit & CSV import. With this app, you can edit any product parameter more automatically, using the same bulk edit options found within the Shopify Bulk Editor, including country of origin!

 

There is a free plan available with this app, so please install it on your store and test it out to see if it works as needed. If you have any questions about it’s functionality, please reach out to the app developer directly. 

 

Hope this helps!

Helen | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

0 Likes
mctenold
Shopify Partner
42 0 5

@Helen Can you explain why Country of Origin can't be added at the import level?

0 Likes
Helen
Shopify Staff
Shopify Staff
887 93 139

Hey, @mctenold. Great question!

 

Honestly, there isn’t a specific reason why this isn’t included at the import level at this time. However, the Shopify platform is continuously improving and adapting to the needs of our merchants, and we rely on great feedback like this to know how to make it better for you.

 

Therefore, I have let our developers know that including a Country of Origin column within the CSV template is something that has been requested. Thank you for that!

 

If you have any further questions or comments, please let me know.

Helen | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

0 Likes
Mage
Tourist
4 0 2

Country of Origin is especially tedious to add in the Bulk Editor because it is a drop-down list, ugha

YES, Please added to export.

0 Likes
NAldo
Tourist
3 0 0

I share this request to have Country of Origin and HS Code added to the CSV import. 

In the meantime, here is a decent work around that doesn’t require paying for a 3rd party app: When you’re in the bulk editor, after you add the Country of Origin and/or the HS Code columns to the editor and have all your products selected, you can grab multiple rows of product by holding down the shift key. Specifically: click the COO field at the top of your list, hold shift, then select the one at the very bottom of the page while holding shift and then the entire page will be selected. Once multiple rows of the field you want to edit are selected you then just need to select your country from the pull down and it will update on ALL the rows you’ve highlighted.  It makes the process much faster, allowing you to update the field page by page instead of item by item. 

0 Likes
Mage
Tourist
4 0 2

That works, but what is the trick to get the pull-down to open without de-selecting?

I got the dropdown to open a couple of times but not consistently.

0 Likes