How Do I Map Multiple SKUs to a Universal SKU?

If your products you wish to map have a similarity we can identify, we can map them all to one SKU with the Rules Engine

Use Case: All SKUs that start with "AB" are going to be mapped to a common SKU called "ABC123".

Basically, all these SKUs below would be changed:

• AB84924824 -> ABC123
• AB0000 -> ABC123
• ABABAB -> ABC123

How Do I write this Rule?

Are you using QuickBooks Enterprise or QuickBooks Online?

• Connex Desktop Rules Engine
• Connex Online Rules Engine

1. When reaching the Rules Engine, click "Add New Rule"
2. Choose the Template "Map SKU"
   
3. Give the rule a name of your choice (the more descriptive, the better)
4. Keep the rule action as "Map SKU"
5. Click "Edit" on the condition
6. Set "Map From" to "AB"
7. Set the Comparison to either "Starts With" (if you are using an order prefix) OR "Contains" (if it doesn't matter where the AB exists in the SKU)
   
8. Click Next, and enter "ABC123" under the "Map To" field
   

After that, you should be all set!