Prices update access project
The objective of this project is to update our online (magento) store by creating a bulk update project file and a new products csv file that would be used in magento for existing products and new products.
Product pricing is for all products are is provided in an excel spreadsheet. This file consists of the following fields:
• UPC (SKU)
• Unit Srp$ - cost price
General Notes about the product pricing file
For the upc to be used, all leading zeros must be eliminated prior to using it in the comparison process below as there are no leading zeros in the sku’s of the existing database.
I will need you to create a access project that takes this file (standard format) prices files, compares it to our existing database buy matching sku’s.
Once a match has been made, prices will be compared to determine if it is different.
An update file will be created for all products whose prices are different. That update file will consist of the following fields:
Cost = price from update file/0.81673
New Products File
The fields in the new products file will be
Short Description = Name + “No. of Items in Pack”+Pack+”, Container Size”+Size+” “ +UOM
Description = Name + “No. of Items in Pack”+Pack+”, Container Size”+Size+” “ +UOM
Category = |ezshop|groceries |+ userspecified subcategory
Cost = (the provide cost from the pricing update file / 0.81673)
Price = Cost * 1.10 (mark up of 10%)
A user interface will be created that allows:
1. Browse for the pricing update file and import the data in.
2. Execute pricing update file generation
3. Review Pricing update file generation results
4. Save the pricing update file
5. Execute new product file generation
6. Review new product file generation results
7. Save the new product file
8. Add the new products to the existing database including the date that it was added
All execution activities should be done via buttons. All saving processes should allow for browsing to where you would like the file to be saved as well as allow for the name of the file to be entered.