Update SKU Identifier
Extract SKU and barcode data, generate identifier mappings in CSV format, and upload the file to an FTP server for external integrations.
Overview
The RIS-SM-1035 – Update SKU Identifier macro extracts SKU and barcode data from Linnworks inventory and generates a structured CSV file.
It creates identifier mappings such as EAN and custom IDs, making the data ready for external systems and integrations.
Ensure barcode data is properly maintained in inventory and FTP configuration is valid before execution.
Purpose
This macro:
- Extracts SKU and barcode data
- Generates identifier mappings (Custom ID & EAN)
- Creates a structured CSV file
- Uploads the file to FTP
👉 In short:
Get SKU + barcode → create identifier CSV → upload to FTP.
When It Runs
Used for product data export and integration workflows
Typically runs:
- Scheduled automation (daily / periodic)
- Manual execution
- During marketplace synchronization
- For barcode and identifier exports
Parameters
FTP server URL.
FTP username.
FTP password.
Destination folder path on FTP server.
FTP port number.
Enable or disable secure FTP (SSL).
How It Works
Start Macro
Begin execution and run SQL query to fetch stock item data.
Fetch SKU Data
Retrieve SKU and barcode data while applying filters:
- Exclude archived, deleted, and composite items
- Remove duplicates using ROW_NUMBER
Prepare CSV Structure
Create CSV headers: SKU, Barcode, IdentifierName, IdentifierType
Process SKU Data
For each item:
- Extract SKU and barcode
- Use SKU as fallback if barcode is missing
Generate Identifiers
Create two identifier entries:
- Custom ID → uses SKU
- EAN → uses barcode
Build CSV Content
Append identifier rows and build CSV content in memory.
Upload to FTP
Upload file SKUIdentifiers.csv to FTP server.
Validate Upload
Verify upload success and log result.
Log Execution
Record execution status, data processing, and errors.
Final Result
-
CSV file generated with SKU identifiers
-
Includes both Custom ID and EAN mappings
-
File uploaded successfully to FTP
-
Data ready for external integrations
Usefulness
This macro is highly beneficial for:
- Centralizing SKU identifier data
- Supporting marketplace integrations
- Automating barcode exports
- Ensuring consistent product data
- Reducing manual effort and errors
Important Notes
-
Depends on accurate barcode data in inventory
-
Uses SKU as fallback if barcode is missing
-
SQL query must be maintained for correctness
-
FTP credentials must be valid
-
Large datasets may impact performance
-
File overwrite behavior depends on FTP configuration
Example Scenario
Key Insight
By standardizing SKU identifier mappings and automating CSV generation, this macro ensures consistent, integration-ready product data while eliminating manual processing and data inconsistencies.
Last updated today
Built with Documentation.AI