Use cases — Page 3

Spreadsheet data

How to remove text before a character in Excel

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

Open

Spreadsheet data

How to add a prefix and suffix to SKU values in Excel

Turn SKU 00123 into US-00123-CA in bulk with two transformations: add text at the beginning and at the end.

Open

Table transformations

How to extract California sales tax from a tax-included price

Split a California tax-included price into price before tax and sales tax amount in separate columns.

Open

WooCommerce CSV

How to Fill Backorders allowed? for WooCommerce CSV

An exact dictionary converts a supplier backorder policy to values accepted by WooCommerce's built-in CSV importer.

Open

WooCommerce CSV

How to Fill WooCommerce In stock? with 1/0 Values

Fill WooCommerce In stock with 1 or 0 from supplier stock quantity and availability status.

Open

Shopify CSV

How to Fill Shopify SEO title When It Is Empty

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

Open

Shopify CSV

How to Fill Shopify Requires shipping for Digital and Physical Products

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

Open

Shopify CSV

How to Fill Shopify Continue selling when out of stock

Prepare Shopify Continue selling when out of stock for preorder and regular products without manual CSV edits.

Open

Shopify CSV

How to Fill Shopify Inventory tracker

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

Open

Google Merchant

How to Exclude a Product from Shopping Ads with excluded_destination

An exact excluded_destination=Shopping_ads rule driven by an explicit item status, without partial matches.

Open

Google Merchant

How to Normalize energy_efficiency_class for Google Merchant

Remove spaces, uppercase the value, and reject unsupported energy-efficiency classes before feed export.

Open

Google Merchant

How to Build unit_pricing_measure such as 750ml or 1.5kg

Prepare unit_pricing_measure from package size so Google Merchant receives values like 750ml or 1.5kg.

Open

Google Merchant

How to Build shipping_weight in the 3 kg Format

Build Google Merchant shipping_weight by converting grams to kilograms and adding the unit.

Open

Google Merchant

How to Set promotion_id Only for Products in a Sale

Add promotion_id only to sale products so promo codes do not appear on regular items.

Open

Google Merchant

How to Build custom_label_0 from Price Ranges

Build custom_label_0 from price ranges to segment products for Google Merchant campaigns.

Open

Google Merchant

How to Send adult=yes for Adult-Oriented Products to Google Merchant

An exact adult=yes rule based on an explicit adult-content flag, without treating every 18+ label as adult content.

Open

Google Merchant

How to Normalize Product Condition for Google Merchant

An exact dictionary maps supplier condition labels to Google values and leaves unknown input blank.

Open

Google Merchant

How to Populate gender for Google Merchant from an Explicit Source Value

Exact mapping to male, female, and unisex from an explicit source value, with no unsafe default.

Open

Google Merchant

How to Set Google Merchant age_group from Exact Supplier Categories

Map confirmed categories to all five age_group values and leave every unknown category blank.

Open

URL / CRM / Accounting

How to merge Debit and Credit into one Amount for Xero

Merge separate Debit and Credit columns into one signed Xero Amount value.

Open

Accounting: QuickBooks

How to split an amount into Credit and Debit for QuickBooks

Split an amount into Credit and Debit without removing the transaction, and remove the minus sign from Debit.

Open

URL / CRM / Accounting

How to normalize HubSpot Lifecycle Stage values

Map local lifecycle labels to accepted HubSpot Lifecycle stage values before CRM import.

Open

URL / CRM / Accounting

How to build a personal PDF link for a Mailchimp merge field

Build a personal PDF link from the customer identifier so Mailchimp receives a ready link for each contact.

Open

URL / CRM / Accounting

How to prepare an email column for Mailchimp import

Prepare Mailchimp Email Address values by removing spaces, lowercasing emails, and filtering invalid rows.

Open