Skip to content
PRDs
Brand Experience
Claims
Discovery & Browsing experience
Moonshots
Cataloging
Compliance
Ads
Search
Others
Selection
Share
Explore

Catalog grouping for CSV uploads

⁠
https://coda.io/d/Catalog-grouping-update-for-bulk-uploads-PRD_dNI3ctomeMK/Catalog-grouping-update-for-bulk-uploads-PRD_suFRwEB-#Table-3_tuC-5pMi/r6
⁠
⁠


Objective -
Updating the catalog grouping logic in bulk uploads to assist new POD categories / brands in adding single product listings in bulk
As per legacy, Bulk uploads automatically tags 4 random products in one catalog if the file has distinct group ID in all rows. There are other such logics present in grouping which need a revamp
Was setup keeping fashion portfolios in mind
Doesn't makes sense for new POD categories such as books
Doesn't allow sellers to add single product listings in bulk

Current grouping logic -
Case I -
Soft QC and catalog grouping - p0
1
Product count <=7
2
Product count > 7, unique group ID for every product
3
Product count > 12, same group ID provided for all the products
4
Product count >7 and group ID provided for all the products and not like 2 and 3
5
Product count >7 and group ID not provided
6
If group ID is different for the size variations of the same product
7
Any combination of 2,3,4,5,6
8
All
There are no rows in this table
⁠

Note: The above rules should hold true for all the files uploaded by internal agents as well.

Case II -
Automated Grouping Logic when products > 7 and there is no group ID - p0
1
4x
Group 4 products per catalog
2
4x + 1
First 5 products into 1 catalog, rest 4 products per catalog
3
4x+2
First 6 products into 1 catalog, rest 4 products per catalog
4
4x + 3
First 7 products into 1 catalog, rest 4 products per catalog
There are no rows in this table
⁠
Required updates -
Automated grouping logic in case 1 would need a revamp
The feature would be a SSCAT level property so users have the control to make the change for respective SSCATs - Tech to get back on the effort and feasibility
By default, updated grouping would remain as false per SSCAT
We’d have the control to update the feature via SSCAT attribute update / upload uploader on admin panel

Updated grouping logic -

1
Product count <=7 and group ID present in some and missing in others
2
Product count <=7 and group ID missing
3
Product count <=7 and group ID present
4
Product count > 7, unique group ID for every product
5
Product count > 12, same group ID provided for all the products
6
Product count >7 and group ID provided for all the products and not like 2 and 3 and product count per group <=12
7
Product count >7 and group ID not provided
8
If group ID is different for the size variations of the same product
8
Across cases, product count in a group shouldn’t cross 12. If >12 then →
9
All
There are no rows in this table
⁠
Guiding principle for new grouping -
Use seller provided group ID to classify catalogs except the case when -
Seller uses same group ID for >=12 products
Seller uses multiple group IDs for different variation of the same product
In all other cases, without Group ID detail, use automated grouping
eg - 100 products in a file with the following distribution -
Group 1 has 4 products→ Catalog 1 with 4 products
Group 2 has 20 products → 5 catalogs with 4 product (Automated grouping)
Group 3 has 10 products → One catalog with 10 product
Group 4 has 20 products → 5 catalogs with 4 product (Automated grouping)
No group has 46 products → 12 catalogs with ~4 products (Automated grouping)

Ticket -
https://meesho.atlassian.net/browse/CT-473
⁠
⁠

Rollout - Phased rollout at a SSCAT level

Enabling attribute -

Mixpanel / Instrumentation - NA
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.