Auto Mapping SKU

RIS-SM-1002 Automapmacro

The Automapmacro application contains a macro designed to operate within a Rules Engine action. Its purpose is to automate the mapping of SKU codes for products or items within an inventory system. This process involves identifying unmapped SKUs and mapping them with the corresponding SKU codes in the Linnworks system if specific conditions are met.

This guide provides a step-by-step explanation of how to install and set up the macro in Linnworks.

Start using the macro

There are three steps you need to complete to start using the macro:

1. Install the application.

   • Go to Apps > Application Store > Automapmacro > click Install and follow the on-screen instructions until the installation is complete.

2. Configure the macro.

3. Configure the rule in the Rules Engine screen.

Configure the macro

Once the Automapmacro app is installed:

1. Go to Apps > Macro Configuration and click + Add new configuration.

   
2. Select the Automap macro and click Create Configuration..

   
3. In the Macro Configuration screen, specify the below details and click Save:

   

4.Make sure to enable the macro to continue with the Rules Engine configuration.

Functionality:

1. Parameters:

   • skuformat: Format or pattern used for SKU codes.

   • source: Source from which the SKUs are obtained.

   • subsource: Subsource or additional criteria for SKU identification.

2. Scheduled Execution:

   • The macro is scheduled to run at predefined intervals, ensuring regular checks for unmapped SKUs.

3. SKU Mapping Logic:

   • The macro scans the inventory system to identify SKUs that are currently unmapped.

   • For each unmapped SKU, it checks if the corresponding channel SKU matches the Linnworks SKU exactly.

   • If the channel SKU matches the Linnworks SKU, the macro automatically maps it.

4. Rules Engine Integration:

   • The macro is integrated within a Rules Engine, allowing it to execute based on predefined conditions or scheduled intervals.

5. Logging and Error Handling:

   • The macro includes logging functionality to record actions taken, such as mappings and any errors encountered during the process.

Usage:

• Parameters:

  • skuformat: Specifies the format or pattern used for SKU codes.

  • source: Indicates the source from which the SKUs are obtained.

  • subsource: Optional parameter providing additional criteria for SKU identification.

• Execution:

  • The macro is scheduled to run at regular intervals as defined by the user.

  • Upon execution, it scans the inventory system for unmapped SKUs based on the specified parameters.

  • For each unmapped SKU found, the macro checks if the channel SKU matches the Linnworks SKU exactly and maps it if conditions are met.

• Outcome:

  • Unmapped SKUs that match the Linnworks SKU exactly are automatically mapped, streamlining the inventory management process.

  • The macro reduces manual effort required for SKU mapping, ensuring that product data is accurately synchronized across systems.

  • Logs generated during the process provide visibility into mappings performed and any errors encountered.