Grocery promotions excel vba solution
$250-750 AUD
Paiement à la livraison
Lencia fruit juices sells beverages to grocery stores.
We regularly run promotional programs for our items with these grocery stores. The promotions are presented as a $ discount to the store, and an associated recommended discount to the customer, along with start/ end dates, contact information, item attributes, comparisons of gross profit per item for the store etc.
Whilst the promotions, and information each grocery store requires are the same, each grocery store insists upon the promotion being submitted to them in their own customised excel format.
The project: develop in excel a reliable, accurate and efficient program to enter the promotional information once, and then generate each grocery stores format from this one source
1) Develop a master template/s to record all the details of promotions for all items for different time periods
2) Identifying which promotions should be submitted to each grocery [url removed, login to view]:
a) upload sales history by grocery store to identify which items the stores parent company and/ or related company has already, or can, purchase; map that to the items on promotion for the selected period and create a store specific promotional template for those items only
b) identify items the parent company/ related store is NOT yet purchased and opt to include these item/s in the promotional template (eg: where a new item is being launched)
c) Override: remove items manually from the results of a & b for a specific store or group of stores
3) Create each stores promotional template in their format
4) Create excel files of promotions for each store for emailing to the store; and/ or automate the email creation & excel attachment process
Constraints
a) the stores promotional templates: minor differences to formatting/ structure of each stores template is allowable, however as much as possible we must conform to the stores format otherwise they will reject our promotion submission
b) Data: there are various constraints around data formatting, date formatting, date time duration, date format etc in the attached file
c) Data source: store sales history, item details, promotional details master data is held within netsuite and can be easily extracted to csv/ excel for use
Your proposal:
- pls provide an overview of how you would approach this exercise
- any suggestions of alternative methods/ approaches
- pls give examples of similar projects you have done
- an estimate of project cost and duration
Skills
- excellent English & communication
- some experience/ knowledge of grocery promotion structures, terminology etc is highly desirable
Attachments the attached excel file contains
- Key: explaining key promotional information
- Store templates: each grocery stores template, with the fields mapped to the key
Nº du projet : #5969074
À propos du projet
14 freelances font une offre moyenne de 487 $ pour ce travail
Hi Paul. I have thoroughly read the requirements and have understood the scope. Firstly, how many different templates do we need to address ? There are 10 different templates in attached file, are there more to them ? Plus
Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award
Hi, The solution can be developed as and Excel VBA solution or it can be even be an interface developed using language like .Net which after accepting necessary inputs from the use can fill the values in Excel templ Plus
Hello - I recommend we consolidate all the available data into a repository sheet and then from there we can make the customer specific sheets on click of macro button. If you like we can discuss all possibilities and Plus
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Plus
I can start working this project. Let me handle this project. I can accurately sort all information needed. Proven skills and experience similar to my previous work. I am looking forward for your response to get starte Plus
Hi, I will not write about my skills you can view it at website. What we can do 1. Create a data base in back end 2. update data base for each promo store wise 3. file store based on past history for promotion Plus
Hello, Warm Greetings from Shweta in Bangalore India. I have a quick solution to you instead of a VBA based application, which is very slow. I can provide you with a Perl based desktop application that can be Plus
Hello, I can make such tool. I had made such tools for using Facebook and one for Travel Agent and can do this easily. WE can discuss sometime and we can discuss for improvements otherwise I will do as i develop Plus