Mad Gusto Help Center

Source Sheet: the rows you want to enrich.

Lookup Sheet: the information you want to fetch.

Target Sheet: where the results go. Often this is the same as your source sheet.

Key columns must contain matching values between sheets, such as SKUs, IDs, or email addresses.

• Source Key Column: from your source sheet.
• Lookup Key Column: from your lookup sheet.

This controls which lookup columns are copied over and where they are placed.

• Column to Return: the column in the lookup sheet to fetch.
• Target Column: where DataJoiner should place the value.

Blank results: key values usually do not match exactly. Check for spaces, inconsistent formatting, or mismatched IDs.

Wrong value returned: duplicate lookup keys can return the first matching value. Make sure the first match is the one you want.

Return column cannot be left of lookup key: move the return column to the right of the key column before running the join.

Create the Neto order and product exports, check the generated HTTPS URLs, then submit them through the secure account setup form.

Open setup guide   Account setup

Learn about the Codex-assisted workflow for preparing product specification data for Neto catalogue work.

View Specs2Neto project