Skip to main content

Bulk Update Variant Connections

Written by Daniela

Bulk Update Variant Connections is the cleanup and correction tool for existing Artelo connections. Use it when the product sets already exist, and you need to remap marketplace variants to different Artelo products without rebuilding the listing.

Like Bulk Connect Without Changes, this is a store-specific workflow. If you need to update both Shopify and Etsy listings, run the tool separately for each store.

What The Tool Does

When you run Bulk Update Variant Connections, Artelo updates which product each selected marketplace variant connects to.

For the rows you mark as Update, the tool will:

  1. Reassign a variant from one product to another product inside an existing product set.

  2. Update a bunch of mappings at once.

  3. Reconnect the updated variants in the marketplace integration after the Artelo mapping changes.

On Shopify only, the flow may also:

  1. Generate missing SKUs for connected variants.

  2. Assign connected variants to Artelo for fulfillment.

This tool does not create a new listing structure, and it does not create new product sets for the listing. It works with existing product sets and products.

When To Use It

Use this tool when:

  1. A listing is already connected, but one or more variant-to-product mappings are wrong.

  2. You want to reassign variants to different products within an existing product set.

  3. Your listings were disconnected accidentally and you'd like to reconnect them.

Tutorial

Step 1: Generate The Workbook

  1. Open Bulk Update Variant Connections.

  2. Select the store you want to work on.

  3. Use filters to narrow the export if needed.

  4. Generate the workbook.

  5. Open the two tabs: Variants and Artelo Products.

The Variants tab is the working sheet.

The Artelo Products tab is your reference sheet for valid product choices inside each product set.

Step 2: Update The Mapping

  1. In the Variants tab, set Operation to Update for each row you want to change.

  2. Choose the correct Product Set.

  3. Choose the correct Product.

  4. Use the Artelo Products tab to confirm the exact product wording.

  5. Keep an eye on Option Values so each marketplace variant is mapped correctly.

The main columns you edit are:

  1. Operation

  2. Product Set

  3. Product

The most helpful reference columns are:

  1. Listing Image

  2. Title

  3. Option Values

  4. SKU

  5. Listing ID

  6. Variant ID

  7. Listing URL

  8. Artelo URL

Step 3: Avoid Common Mistakes

  1. Do not leave Operation blank on rows you expect to process.

  2. Do not assign a product that does not belong to the selected product set.

  3. Do not map the same product to multiple variants within the same listing unless that is truly the intended final state.

  4. Start with a small test batch before updating every listing in the store.

Step 4: Upload And Submit

  1. Upload the completed workbook.

  2. Fix any row-level errors if the tool returns an error sheet.

  3. Submit the flow once the upload is accepted.

  4. Verify several listings in Artelo after the update completes.

Did this answer your question?