Login / Sign up
URL / CRM / Accounting

How to extract an Amazon ASIN from a URL

2026-06-21
Task

A feed contains Amazon URLs, while product matching needs a separate asin column with the 10-character product code.

Short answer

Create asin from the URL and keep only the 10-character ASIN with a regular expression.

How to do it in Eofferix

  1. Upload the table with Amazon URLs and open the table editor.
    ASIN extracted from Amazon URLs in Eofferix
    The output asin column is built from the source Amazon URL.
  2. Create asin from amazon_url and add a Regular expression -> Remove everything except rule.
    Regular expression rule for ASIN
    The rule keeps the 10-character alphanumeric ASIN segment.
  3. Use [A-Z0-9]{10} for /dp/, /gp/product/, and /d/ URL forms.
  4. Save the template and test several URL variants.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data
skuamazon_url
SKU-1001https://www.amazon.com/dp/B08N5WRWNW/ref=something
SKU-1002https://www.amazon.com/gp/product/B07PGL2ZSL

After

result
skuasin
SKU-1001B08N5WRWNW
SKU-1002B07PGL2ZSL

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up