Bulk pasting barcodes for products

que_shebley
Tourist
6 0 1

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

channelup
Shopify Partner
379 16 52

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

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
If you require custom development or would like to test out our features contact me at tom@channelup.io
0 Likes
PaulNewton
Shopify Partner
2601 136 475

 




@que_shebley 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.

 

 

 

 

 

Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com
Renars
Shopify Partner
120 18 120

Hello @que_shebley 

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
0 Likes