How to Generate a Missing SKU List

1. Navigate to the Imports Section

  1. Log in to your OneCart account.
  2. Go to Imports and select View Imports.
  3. Here, you will see a list of imports pulled from your connected e-commerce platforms.

2. Generate the Missing SKU List

  1. Click on Reports and select Generate Missing SKU List from the dropdown menu as per image below

3. Export or Take Action

  • Export the Missing SKU List:
    • Use the Export option to download a CSV file of the missing SKUs for offline review and updates. Below is a sample of how it would look like.
  • Manually Update SKUs:
  • Bulk Update SKUs:
    • Alternatively you can sse the Bulk Upload feature to upload a file with corrected SKUs for multiple products. You can refer to this article - https://help.getonecart.com/help/adding-your-inventory-to-onecart-bulk-upload

Best Practices

  • Regularly Review Imports: Check for missing SKUs after each import to ensure data accuracy.
  • Utilize Bulk Uploads: Save time by using bulk uploads for multiple SKU updates.
  • Coordinate with Shops: Ensure your connected shops consistently use SKUs for all products to avoid mismatches.

Frequently Asked Questions

Q: What happens if I leave SKUs missing?
A: Missing SKUs can result in inventory discrepancies, making it difficult to track stock levels and fulfill orders accurately.

Q: Can I regenerate the Missing SKU List after updates?
A: Yes, once you update the SKUs, you can refresh the Imports section to view the updated data.

Q: How do I assign SKUs for inactive listings?
A: Inactive listings can be reactivated and edited to include the missing SKUs.