Accurately aligning your Shopify product types with M1 class codes ensures clean reporting, improved inventory management, and better automation. Follow these step-by-step instructions to efficiently update product classifications using Shopify's Bulk Editor.

1. Accessing the Shopify Bulk Editor

1. In your Shopify Admin, go to Products.
2. Use the search bar or filters (e.g., tags, keywords) to find the items you want to reclassify.
3. Select products by clicking the Select All checkbox.
4. If there are more than 50 items, click the “Select all 50+ items” hyperlink that appears.
5. Click Edit to open the Bulk Editor.

2. Adding the "Custom Product Type" Column

1. In the Bulk Editor, click the Columns button (top right corner).
2. Select Custom Product Type to display this field for editing.

3. Reclassifying Product Types to Match M1 Class Codes

1. In the Custom Product Type column, copy and paste the correct M1 class code for each product.
2. To apply the same product type to multiple items:
   • Enter the correct M1 class code in the first row.
   • Click and drag the small blue square (bottom-right corner of the cell) downwards to fill multiple rows.
   • Use the down arrow on your keyboard while dragging to extend the selection quickly.

✅ Tip: Ensure all classifications align with your M1 structure to maintain accurate data and reports.

4. Identifying and Classifying "Unclassified" Items

Unclassified items lack a Custom Product Type and can disrupt reporting if left unchanged.

1. Go to Products in Shopify.
2. Ensure all filters are cleared.
3. On the right side, click Sort → Sort by Product Type A-Z.
4. Products without a type will appear at the top with an empty “Type” field.
5. Select all unclassified products and assign appropriate M1 class codes.

5. Excluding Dropship Items

🚨 Important: All dropship items must be excluded from the reclassification process to prevent inventory misrepresentation.

1. Identify dropship products and do not assign them an M1 class code.
2. Ensure they remain clearly labeled as excluded from classification.

6. Implementing Week Tags for Inventory Aging

Adding week tags during receiving helps automate markdowns and track inventory age.

1. During receiving, assign a tag reflecting the week number of the year (e.g., Week32 for the 32nd week).
2. Use this information to track product age:
   • Example: Women’s apparel typically has an 8-10 week shelf life. If a product was received on Week32, it should be considered aged by Week40.
3. Reference a week calendar (e.g., Epoch Week Converter) to ensure accurate week tracking.

✅ Best Practice: Print a week calendar for in-store use and integrate week tagging into your receiving workflow for better inventory management.

7. Final Review Checklist

✔ Ensure all Custom Product Types align with M1 class codes.
✔ Verify no products are left unclassified.
✔ Confirm dropship items remain excluded.
✔ Implement week tags to track product aging and automate markdowns.

• Shopify Bulk Editor - Product Type Reclassifying.pdf100 KB