We need a VBA and Excel export to help us automate our master assortment generation. Many other jobs will follow if we are happy with what you did.
We are an e-commerce company. Our business is built around a catalogue of 7,000+ items. This catalogue is split into 8 categories (called attribute sets). We want to automate the generation of our master assortment based on attribute sets exports. Files have different format and require some reformatting. A VBA macro should do the job.
- Attribute sets exports
- CSV format
- Currently 8 attribute sets, but will grow in the future
- Select attribute set paths
- Aggregate all the attribute sets in one sheet
- Run various formulas to retrieve some info that is not in the attribute sets
- Master assortment (should include selected info only, not the entire content of the attribute sets)
- XLS format
- CSV files include Arabic content. Be careful with the character set
11 freelancers are bidding on average $17/hour for this job
Hello, I have read your requirements and would be glad to help you with the automation of generating the master file. Please check your PMB for further details.