Skip to content

Clean up AliExpress and DSers imports in Shopify

Updated 21 Oct 2026 · 11 min read · Markdown

Imported products carry the supplier's structure: a "Ships From" option with China and United States, colours called "Color 1" and "Color 2", variants in the order the factory listed them, and a description that says "Imported from AliExpress". Each of these is a per-product edit in the Shopify admin. ApiMate runs each one across every imported product from one instruction, and shows every product it will change before anything is written.

The video above is four real runs on four products a DSers-style import left behind, vendor Pawtrail Supply. Each had a Color option with three values and a Ships From option with China and United States, so six variants, and the same supplier paragraph at the end of the description. The four instructions, in this order: remove Ships From and keep the US variants (8 changes, the only one-way step); rename Color 1, 2, 3 to Black, Grey, Navy (4 of 4 verified); sort the variants cheapest first (4 of 4); take the supplier paragraph out of the descriptions (4 of 4). Each has its own clip below.

The trap is the option delete. Removing "Ships From" from a product with two origins and three colours deletes three of its six variants, and Shopify cannot bring them back. The preview names the three that go on every product, the card says "This cannot be undone", and Apply stays grey until you tick "I understand this permanently destroys data".

Four cleanups on DSers imports in Shopify: option, colour names, order, descriptions · 1 min

Who runs this job, and why now

Dropshipping apps import what the supplier has. The supplier has a "Ships From" option because they ship from two warehouses; your customers do not choose a warehouse. The supplier calls a colour "Color 3" because the factory does; your customers want "Navy". The supplier's description says "ships from China mainland in 15-30 days", which is their promise, not yours, and Google Merchant Center reviews the text on your product pages.

Twenty imports is an afternoon in the admin. Two hundred is not, and by then those variants have orders against them, so the cleanup has to keep the variants customers already bought. Re-importing gives the variants new ids, and the order and inventory history stays with the old ones.

The other reader is a merchant moving off dropshipping to their own stock. The products stay, the supplier structure goes, and the cleanup is the last step before the store looks like a brand rather than someone else's catalog.

How this is done without ApiMate

In the Shopify admin: open the product, edit the option, rename or delete the values, save. Drag the variants into order. Edit the description. Then the next product. The bulk editor does not cover options, so the product page is the only place to do it, one product at a time.

Import apps can map option names and values at import time. That helps the next import and does nothing for the products already in the store. A CSV round trip can rename option values, because they are columns, but deleting an option means rewriting every variant row of every product, and descriptions in a CSV are one HTML cell per product.

Four instructions, in this order

A pet-supplies merchant once wrote the whole job as one sentence: "Clean up and reorganize variants, cheap to most expensive, make the names more professional, remove anything that mentions a country or mainland." That is four jobs with four different previews, and four different risks. Send them one at a time, in this order: the option delete first (fewer variants left to rename), the renames second, the sort third (it needs the final variant set), the descriptions last.

Each instruction names the thing a vague sentence leaves out: which origin to keep, what each colour is called, the direction of the sort, the text to remove. Scope by vendor or by the tag the import app adds, so products you made by hand are not in the plan.

  • For every Pawtrail Supply product, keep the "United States" variants and remove the "Ships From" option.
  • On every Pawtrail Supply product, rename the Color values: "Color 1" is Black, "Color 2" is Grey, "Color 3" is Navy.
  • Reorder the variants of every Pawtrail Supply product from cheapest to most expensive.
  • Remove the paragraph about shipping from China mainland and AliExpress from every Pawtrail Supply product description. Keep everything else exactly as it is.

Remove the "Ships From" option

Deleting an option deletes every variant built from it, so "remove Ships From" alone does not say which variants survive. Naming the origin to keep does. In the run below ApiMate planned two writes per product: delete the three China variants, then remove the Ships From option. The US variants stayed, with their ids, prices and stock, and the option is gone from all four products: 8 changes in one task.

Every product shows both rows in the preview: "Options: Ships From: China, United States", struck through, and "3 variants", with the three that go named: "Color 1 / China, Color 2 / China, Color 3 / China". Above the rows the card says "This cannot be undone", and Apply stays grey until "I understand this permanently destroys data" is ticked. After the job, the card ends on "Done — every change verified" and offers no Undo, because there is nothing to undo with.

Instruction

For every Pawtrail Supply product, keep the "United States" variants and remove the "Ships From" option.

  • Name the value to keep. The variants of every other value are the ones deleted.
  • Read the "variants" row on each product: that is the list Shopify deletes.
  • Stock on the deleted variants goes with them. Move it first if it matters.
  • A product must keep at least one variant; Shopify refuses to delete the last one.
Removing the Ships From option and the China variants from four products · 30 s

Give the colours real names

A variant's title comes from its option values, so the rename is done on the option, not on each variant. One row per product, the option named in the title ("No Pull Dog Harness Reflective Adjustable — Color"), and the line under it is the whole rename: "Color: Color 1, Color 2, Color 3 → Black, Grey, Navy". The variants keep their ids, SKUs, stock and orders; only the names change.

ApiMate does not guess that "Color 3" is Navy. The map comes from you, and the values in the store are matched against it exactly. In the run, all four products were renamed in one approval, 4 of 4 verified, and the card offers Undo: the old names are kept and can be written back.

Instruction

On every Pawtrail Supply product, rename the Color values: "Color 1" is Black, "Color 2" is Grey, "Color 3" is Navy.

Renaming Color 1, 2, 3 to Black, Grey, Navy on four Shopify products · 33 s

Sort the variants by price

Shopify shows variants in their stored order, in the variant picker and in the admin. Sorting by price touches no values, only positions. ApiMate reads each product's variants and prices, sorts them, and the preview shows the order before and after on every product: "Variant order: Black, Grey, Navy → Grey, Navy, Black" on the harness, where Grey is 22.99, Navy 24.99 and Black 27.99.

Each product gets its own order, because the prices differ: on the water fountain the same instruction gave "Grey, Black, Navy". One approval moved all four, 4 of 4 verified, and Undo puts the previous order back.

Instruction

Reorder the variants of every Pawtrail Supply product from cheapest to most expensive.

Sorting the variants of four Shopify products cheapest first · 32 s

Take the supplier text out of the descriptions

The description write is the whole description with one paragraph taken out, so the preview shows the whole description twice: as it is now, then as it will be. On the harness the paragraph "Ships from China mainland, delivery in 15-30 days. Imported from AliExpress, contact the seller for wholesale prices." is gone and the three lines above it, the product copy and both bullet points, are unchanged.

Removing text is exact: ApiMate finds the paragraph as it is written in the store and removes it. A plan that names nothing to find is refused before the preview, because it would blank the field on every row. Read two or three of the new descriptions in the preview before you approve. In the run, four descriptions were written in one approval, 4 of 4 verified, and Undo can write the old ones back.

This job removes text. Rewriting descriptions in your own voice is a different job, with generated text and its own preview. Do the removal first so the rewrite starts from a clean description.

Instruction

Remove the paragraph about shipping from China mainland and AliExpress from every Pawtrail Supply product description. Keep everything else exactly as it is.

Removing the AliExpress paragraph from four Shopify product descriptions · 32 s

Reading the four previews

Each card has a first line that is the scope and one row per thing it changes. These are the lines from the four runs on this page.

JobFirst lineEach row showsUndo
Option delete8 changes across 2 kinds of updateThe option struck through, and the variants that go by nameNo. The card says "This cannot be undone"
RenameRename values on 4 optionsColor: Color 1, Color 2, Color 3 → Black, Grey, NavyYes, the old names are written back
SortReorder variants on 4 productsVariant order: Black, Grey, Navy → Grey, Navy, BlackYes, the old order is put back
DescriptionsUpdate 4 productsThe whole description now, then the whole new descriptionYes, the old description is written back

Check the count in the first line against the number of imports you meant.

After approval

Every row is read back from Shopify after it is written and compared with the plan. All four cards on this page ended on "Done — every change verified". Read from Shopify afterwards, each product had three variants named Black, Grey and Navy, sorted by price, no Ships From option, and a description without the supplier paragraph.

Each task stays in Tasks with its rows, which is also the record of what was removed, renamed or moved, and when.

Where the tool stops

Deleted variants do not come back. Their ids are gone, and with them the link to past orders and inventory history. Recreating them is a new job that makes new variants with new ids.

A rule that needs judgement ("make the names more professional") has to become a concrete map before it is a plan. ApiMate works from the names you give it.

Shopify allows three options per product. Merging two options into one changes the variant set, which is a recreate, not a rename.

Supplier images with watermarks are not fixed here. Replacing images needs new images from somewhere.

Other ways to say the same jobs

These come out as one of the four jobs on this page. The preview shows which.

  • "Remove the Ships From option from every product and keep the US variants."
  • "Get rid of the warehouse option on my DSers products."
  • "Rename Color 1, Color 2, Color 3 to Black, White, Navy everywhere."
  • "Sort every product's variants cheapest first."
  • "Delete the sentence about shipping from China from all descriptions."
  • "Which products still mention AliExpress?" (A read, before or after.)

Terms used on this page

  • Option: a product attribute with values, such as Ships From with China, United States. Three per product at most.
  • Option value: one value of an option. Renaming a value renames it on every variant that uses it.
  • Variant: one combination of option values. Deleting an option deletes the variants built from it.
  • Variant id: the identifier orders and inventory history point to. Kept by a rename or a sort, lost by a delete.
  • Description write: the whole description written back with an edit applied. Previewed whole for that reason.
  • One-way: a change Undo cannot reverse. Option and variant deletes are one-way.

Questions

Will removing "Ships From" delete my variants?+

Yes, the variants of the origin you do not keep. Name the value to keep; the preview names the variants that go on every product.

Can I undo an option delete?+

No. Deleted variants are gone with their ids, and the card says so before you approve. Renames, sorts and description edits can be undone.

Can it rename variants on 200 products at once?+

Yes. One row per product, every value it renames on that row, and one approval for all of them.

Does it keep the description formatting?+

It removes the text you named and writes the rest back unchanged. The preview shows the whole new description; read a few before you approve.

Do I lose order history on renamed variants?+

No. A rename keeps the variant id, so orders and inventory history stay attached. Only a delete loses them.

Can it decide what "professional" names are?+

No. Give it the map ("Color 1 is Black"); it does not guess a colour from "Color 3".

Should I scope to imported products only?+

Yes, if the store has products you made by hand. Imports usually share a vendor or a tag from the app; scope by that.

Does this fix Merchant Center flags?+

It removes supplier and marketplace text from the descriptions. Run the Merchant Center audit afterwards to see what is left, and fix images separately.

Explore More

Related

Run this on your own catalog

Install from the Shopify App Store. Every write shows its rows before it runs, and applied jobs can be reverted from history.