How to Clean Up Purgatory and Use Data Mapping in Luminous
.svg)
- Step 1: Access Purgatory
- Step 2: Resolve Unrecognized SKUs
- Step 3: Optimize Purgatory Settings
- Step 4: Proactive Data Mapping
Effectively cleaning up Purgatory and managing data mapping in Luminous is essential for ensuring that sales orders are routed correctly and inventory is pulled accurately from external warehouses. Follow these steps to streamline your setup.
Step 1: Access Purgatory
- Navigate to Purgatory:
- Go to Shipping > Purgatory in the Luminous dashboard.
- Purgatory acts as a data-cleaning tool, flagging orders with unrecognized SKUs.
- Review flagged orders in red. These indicate SKUs that Luminous does not recognize.
Step 2: Resolve Unrecognized SKUs
Option 1: Add as an Alternate SKU
- Identify the SKU in Purgatory.
- Navigate to the SKUs page.
- Select the relevant SKU and add the flagged SKU as an Alternate SKU.
- This allows Luminous to recognize the flagged SKU as equivalent to an existing SKU.
Option 2: Create a New Product
- From the Purgatory page, use the bulk inline edit function:
- Select the unrecognized SKU.
- Fill out the required product details directly within the Purgatory interface.
- Click Create SKU to generate a new product in Luminous.
Option 3: Map to an Existing SKU
- From Purgatory, map the flagged SKU to an existing Luminous SKU:
- Search for the correct SKU.
- Add the flagged SKU as an Alternate SKU.
- Optional Settings:
- Choose to skip inventory updates or exclude from sales reports if necessary.
Step 3: Optimize Purgatory Settings
- Use the ignore patterns feature to prevent recurring issues with specific SKU formats.
- Adjust Purgatory settings to streamline the process and ensure accurate data integration.
Step 4: Proactive Data Mapping
- Access App Integration Settings:
- Click your name in the bottom-left corner.
- Navigate to App Integration Account Settings.
- Select the connection you want to manage (e.g., Walmart, Shopify, Amazon).
- Click Edit, then ensure Get Products is toggled on.
Manage Product Mapping
- Click Manage Products to view incoming product names and SKUs from the external connection.
- Map the incoming SKUs to existing Luminous SKUs:
- If the SKU exists in Luminous, use the Auto Map SKUs feature to automatically connect them.
- For unmapped SKUs, manually map them to ensure accurate inventory and sales tracking.
By following these steps, you’ll effectively clean up unrecognized SKUs in Purgatory and proactively map external data for seamless integration. This ensures accurate inventory tracking and proper sales order management in Luminous.
Video transcript
Why Purgatory and data mapping matter
This is going to be a quick tutorial about cleaning up Purgatory and the data mapping features inside of Luminous. This is really critical to setting up your account properly, to make sure sales orders are being routed to the correct SKUs and that we're pulling in inventory correctly from all of your different external warehouses.
Part 1: Cleaning up Purgatory
We're going to start in Purgatory, which is under Shipping. If you don't remember, Purgatory is a data cleaning tool in Luminous. Luminous pulls in all of your sales orders from all of your different connections, and it flags orders that contain line items with SKUs it doesn't recognize. You can see on my screen that under Purgatory, Luminous is catching a couple of orders marked in red, because we don't recognize those SKUs.
There are a couple of different actions you can take here. If the product does exist in Luminous but under a different SKU, you can add this as an alternate SKU. If you go to the SKUs page and click on a SKU, you can add it as an alternate SKU there as well.
Back in Purgatory, the next option is creating a new product. If the SKU from this order is a totally different product that doesn't exist in Luminous yet, you can create that SKU.
Bulk inline edit
A good feature within Purgatory is the bulk inline edit function. From the same Purgatory page, you can add this order SKU as a Luminous SKU. It populates with the SKU that was getting stuck, you fill out the needed information, and you can create the SKU directly from there, which makes it really simple.
You also have the ability to map it to an existing Luminous SKU. Search for it, and you have the option to add it as an alternate SKU right there. If you go this route, you can also choose to skip the inventory update, so these orders won't affect your inventory quantities. When I hit Confirm SKUs, it again gives you the option to exclude it from inventory numbers or the sales report. I'm just going to confirm for now.
Overall, Purgatory is a great tool. You also have the ability to ignore patterns and set up different settings to make sure everything comes in properly.
Part 2: Proactive data mapping
Part two is what I'd call a more proactive approach to cleaning data. Under your name, go to App Integration Account Settings. I'm going to click on this Walmart connection, but the same is true for a Shopify connection, Amazon, or a different WMS. I'll click Edit.
You can see Get Products is toggled on, which lets you click Manage Products. There you can see the product names and SKUs coming in from Walmart, in this example, and what those SKUs are mapped to inside of Luminous. This gives you a really good view of which products aren't mapped yet, and what you need to do to make sure all of those products come in correctly, with inventory and with any sales orders pulling from this connection.
I can map these SKUs here. If the SKU is already created in Luminous, you can click Auto Map SKUs, which goes through and automatically maps any that match. That gives you a really good baseline to make sure your data is connected properly and you're set up for success in Luminous. Thanks, guys.