Use cases — Page 2

Supplier catalogs

How to extract color from YML param name="Color"

Create a separate Color node and fill it from the YML param value without mixing it with Material.

Open

Supplier catalogs

How to take stock from the main warehouse in CommerceML

Choose only the MAIN warehouse quantity from a 1C CommerceML export without adding reserve stock.

Open

Supplier catalogs

How to skip CommerceML products marked for deletion

Exclude 1C CommerceML products marked for deletion before importing the catalog.

Open

Supplier catalogs

How to keep only YML offers with the needed currencyId

Keep only YML offers with currencyId USD and remove supplier items priced in another currency.

Open

Supplier catalogs

How to keep only YML offers with a valid url

Complete relative URLs with the supplier domain and exclude products whose URL is empty after normalization.

Open

Supplier catalogs

How to skip JSON variants without SKU or price

Filter a variants array and keep only variants with a non-empty SKU and a numeric price.

Open

Supplier catalogs

How to extract size from CommerceML ХарактеристикиТовара

Create a separate Размер node and fill it from the CommerceML Size characteristic without taking Color.

Open

Supplier catalogs

How to choose a CommerceML price by ИдТипаЦены

Take only the BASE price from a 1C CommerceML export and avoid mixing it with WHOLESALE prices.

Open

Supplier catalogs

How to remove YML offers with available="false"

Exclude YML offers whose available attribute is false before sending the feed to import.

Open

Supplier catalogs

How to keep only selected categoryId values in a supplier YML feed

Filter a supplier YML feed so only offers from allowed categories 101 and 205 are exported.

Open

Supplier catalogs

How to skip JSON products without a main image

Exclude products with an empty image_url so items without a main image are not sent to import.

Open

Supplier catalogs

How to clean currency text from prices in a supplier JSON catalog

Extract the numeric part from JSON price.amount values where the supplier includes USD, EUR, or another currency.

Open

Supplier catalogs

How to sum warehouse stock values in a supplier XML feed

Add several warehouse/stock values inside one offer and write the total into stock_total.

Open

Supplier catalogs

How to keep only XML items with a supplier code and a 13-digit barcode

Add two conditions to a repeated XML node: require a supplier code and a barcode made of exactly 13 digits.

Open

Supplier catalogs

How to remove text prefixes and units from a supplier price list

Clean values such as Price: USD 24.90 and Stock: 12 pcs into separate numeric price and stock fields.

Open

Supplier catalogs

How to normalize availability in a supplier JSON catalog

Map the supplier JSON API value available to in_stock for a unified catalog format.

Open

Supplier catalogs

How to extract delivery time in days from a supplier XML feed

Normalize XML delivery_time values such as 3-5 days and 14 days into a numeric catalog field.

Open

Supplier catalogs

How to skip discontinued products in a supplier XML feed

Configure an XML feed so products with the discontinued status are skipped from the export result.

Open

Supplier catalogs

How to prepare a price and stock update by SKU

Build a catalog update file by SKU when supplier stock is stored as text such as Stock: 12 pcs.

Open

Supplier catalogs

How to prepare a vendor price list for import

Split a supplier price list into vendor code, name, unit price, currency, and MOQ fields before importing a catalog.

Open

Spreadsheet data

How to remove last N characters in Excel

Remove a fixed three-character SKU suffix without writing Excel formulas.

Open

Spreadsheet data

How to remove first N characters in Excel

Remove a fixed three-character SKU prefix without writing Excel formulas.

Open

Spreadsheet data

How to extract a number from text in Excel

Turn stock text such as In stock: 12 pcs into a separate numeric value 12.

Open

Spreadsheet data

How to remove text after a character in Excel

Turn 00123-CA into 00123 by removing everything after the dash and then removing the dash itself.

Open