How can I bulk paste barcodes for individual products without using CSV?

How can I bulk paste barcodes for individual products without using CSV?

shebley_group
Excursionist
15 0 6

Hi,

 

running into an issue with no solution so far. Just to be clear, we DO NOT want to use the CSV route as it brings in some issue for our unique product listings.

Basically trying to paste barcode number for products, so each product i want to copy from excel and paste the barcodes al once for each product. right now the bulk editor in shopify only lets you either paste each one individually under each varient and thats it. if i try to paste for example 10 barcodes at once and choosing 10 varients , it will paste all 10 barcodes to every single varient and not one each as its suppose to.

 

tried many bulk apps including the excel one and it will doesnt work to just paste the in bulk.

 

using a macbook if that makes a difference.

here is a snapshot of how it looks when you trying to paste from "numbers" to the shopify online bulk editor.

Screen Shot 2020-12-30 at 3.33.27 PM.png

Replies 6 (6)

productsync
Shopify Partner
740 38 161

Hey

Can't help with the UI limitation in Shopify but if you can map the barcodes via a unique key that is already in Shopify you could automate the process via API. Not sure if that would still work seeing how you mentioned you have issues with csv importing.

Regards

Tom

PaulNewton
Shopify Partner
7450 657 1562

 




@shebley_group wrote:

running into an issue with no solution so far. Just to be clear, we DO NOT want to use the CSV route as it brings in some issue for our unique product listings.

...

tried many bulk apps including the excel one and it will doesnt work to just paste the in bulk.


CSV is a lingua franca of the business world and not being able to generate the values you need to integrate with process is a critical weakness.

The bulk editor is great for most things but it is not a spreadsheet program with all the modern conveniences excel facilitates.

It has multirow multicolumn selection for editing repeat values, such as changing all variants to the same price.

But it doesn't have multi value multi column pasting.

If your unwilling to address blocking issues with the data exporting, and apps like ?excelify? don't address the problem, that just creates a situation where you will need custom app development if there's some quirk in some admin UI somewhere impeding a workflow.

 

 

 

 

 

Contact paull.newton+shopifyforum@gmail.com for the solutions you need


Save time & money ,Ask Questions The Smart Way


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Thank Paul with a Coffee for more answers or donate to eff.org


Renars
Shopify Partner
307 32 365

Hello @shebley_group 

Renars here from Excelify.

If you are open to using apps then for such a task you can look into using Excelify.
Excelify works with data exports and imports.

You can construct a file that would only update your Product Variant Barcodes.
In your file, you would need to identify the Product and Variant in the product.

You can identify Product by ID or Handle
You can identify Variant by Variant ID or Variant SKU

So create a file with any combination that identifies the Product and Variant you need to update, for example, you can import a file with 3 columns:

  • Handle
  • Variant SKU
  • Variant Barcode

The app would find Product by Handle, find Variant by SKU, and update that variant's Barcode.

If you need more details on how the app works and how you could achieve this task in bulk, please reach out to us directly.
Thank you.

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app

Swift2
Tourist
5 0 1

I know this is an old post but I was wondering if you found a solution to this. I've been wasting time for more than a week going through several Shopify agents that contradict each other and get me nowhere. "Bulk Edit" won't work. Import/Export file won't work because de-scrambling the file is necessary to get all the TRUE values together in order to be able to bulk paste into the appropriate cells. If any one finds a solution to this, please do share. Thank you.

Victoria
Shopify Staff
2398 162 289

Hi, @Swift2.

 

Thanks for joining the thread!

 

I can definitely understand how valuable this feature is and can help save time when adding barcode information to products. I'll be sure to pass along your feedback to our product development team to look into. If you'd like, you can keep an eye on our Shopify Changelog for updates. 

Victoria | 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

Roar_Sweden
Excursionist
47 0 10

This would be awesome if you implented so it can be pasted right into the fields without an app.