Use cases — Page 4

URL / CRM / Accounting

How to get a file extension from a URL or path

Extract the file extension from a URL or path and normalize it to lowercase for filters and checks.

Open

URL / CRM / Accounting

How to get a file name from a URL or path

Take only the file name with extension from a full URL or path, such as price-list.xlsx or manual.pdf.

Open

URL / CRM / Accounting

How to remove a query string from a URL

Remove UTM parameters and fragments from URLs so the export keeps stable clean links.

Open

URL / CRM / Accounting

How to extract an Amazon ASIN from a URL

Extract the Amazon ASIN from product URLs so items can be matched without manual URL cleanup.

Open

URL / CRM / Accounting

How to extract a YouTube video ID from a URL

Extract the short YouTube video ID from watch, short, and embed links into a separate column for import or matching.

Open

WooCommerce CSV

How to Build WooCommerce Images from Several Image Columns

Build WooCommerce Images from several photo columns while skipping empty links and extra commas.

Open

WooCommerce CSV

Fill WooCommerce Backorders allowed?

Map preorder to notify, allowed to 1, and all other rows to 0.

Open

WooCommerce CSV

Fill WooCommerce In stock? with 1/0 values

Write 1 when stock is positive or the source status says in stock; write 0 otherwise.

Open

WooCommerce CSV

How to Normalize WooCommerce Type to simple, virtual, downloadable

Normalize WooCommerce Type to simple, virtual, or downloadable so import creates the right product type.

Open

Shopify CSV

Fill Shopify SEO title when it is empty

Fill Shopify SEO title from the product title only when the source SEO title is empty.

Open

Shopify CSV

How to Fill Shopify Gift card from Product Type

Fill Shopify Gift card from product type so gift cards and certificates are marked correctly in CSV.

Open

Shopify CSV

Fill Shopify Requires shipping for digital and physical products

Separate digital, service, and physical products for Shopify Requires shipping so delivery is enabled only where needed.

Open

Shopify CSV

Fill Shopify Continue selling when out of stock

Prepare Shopify Continue selling when out of stock from sales mode so preorder items keep selling in the CSV import.

Open

Shopify CSV

Fill Shopify Inventory tracker

Fill Shopify Inventory tracker from stock tracking flags so Shopify tracks inventory only for the right products.

Open

Shopify CSV

How to Fill Shopify Published on online store from Product Status

Fill Shopify Published on online store from product status so only active items appear in the storefront.

Open

Table transformations

How to remove rows with invalid EAN/UPC barcodes

Keep only rows where barcode is numeric and has length 8, 12, 13, or 14.

Open

Table transformations

How to Create .99 Prices: Nearest Integer Minus 0.01

A validated rule chain rounds a valid price to the nearest integer, subtracts 0.01, and rejects invalid input.

Open

Table transformations

How to split S, M, L sizes from one cell into separate rows

When sizes are stored as S|M|L, enable row structure changes and split values into new rows.

Open

Table transformations

How to create group_id from product variant SKU

Extract a shared group_id such as TSHIRT-100 from a variant SKU.

Open

Table transformations

How to split image URL lists into main and additional images

Turn one images column into main_image and additional_images.

Open

Table transformations

How to extract color and material from product specifications into columns

Split a specs string into color and material columns with regular expressions.

Open

Table transformations

How to clean extra spaces, line breaks, and non-breaking spaces in product descriptions

Clean description by replacing   with a space, collapsing repeated spaces, and trimming the value.

Open

Table transformations

How to fill blank spreadsheet cells with a default value

When brand is blank, replace it with No brand using an Empty condition.

Open

Table transformations

How to choose the first non-empty product image URL from several columns

Choose the first non-empty image link from several columns so the main product image is filled.

Open