I have some work, in an Excel spreadsheet. Supplying to an Online groceries business
1. Create a template to effectively have all groceries items (10k-20k SKU) in 1 place. Which must include
- packing size
- Preferred supplier
- price from supplier by unit and by carton
(Right now price data given by supplier is all different formats and mostly in PDF)
- recommended selling price (need to crawl from [url removed, login to view])
- From above to be able to auto-calculate my selling price to customer based on a predetermined margin %
2. To be able to map data from customer when they send us the items they want and quantity count.
• Right now file is given but can't map because description is different. Either we have to use their format or we determine a format for them to give us in.