Completato

MS Access Update Proeject

Prices update access project

Project description

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)

• Description

• Pack

• Size

• UOM

• Depart

• 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.

Update File

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:

SKU

Cost = price from update file/0.81673

Price=Cost *1.10

New Products File

The fields in the new products file will be

Name

Sku

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%)

User interface

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.

Competenze: Elaborazione dati, Amministrazione Database, Microsoft Access

Vedere di più: access date update, the container store, product pricing spreadsheet, ms project product, ms access online, microsoft project import, mark fields, import ms project, format pricing, format prices, data access interface, cost to create an online store, container store, buy spreadsheet, price comparison online, online price comparison, objective c category, ms project price, microsoft project price, microsoft excel price

Sul datore di lavoro:
( 27 valutazioni ) George Town, Cayman Islands

ID Progetto: #1313347

Assegnato a:

TCar

Hi, would welcome a chance to do this for you! I'm an Access developer with over 5 years of experience and am available to start on this immediately! Please check your private message for further details about my quali Più

$100 USD in 2 giorni
(6 valutazioni)
4.2

6 freelance hanno fatto un'offerta media di $110 per questo lavoro

Kingpin1962

Kindly check PMB. Thanks...

$80 USD in 7 giorni
(2 Recensioni)
3.2
mindware97

I have read and understood your project requirement. I am a qualified professionals with years of experience in Data entry, Graphic design and web design (HTML/CSS). So far, I have finished more than 100+ various data Più

$200 USD in 15 giorni
(2 Recensioni)
3.2
KarinPinazo

Hello, Please read your PMB. Regards.

$130 USD in 1 giorno
(1 Recensione)
1.0
shuvo1212121

sir plz 1 change me.

$70 USD in 2 giorni
(0 Recensioni)
0.0
Lokmaneng

Dear sir, I’m interested in this project all or your terms & conditions. I’m confident to perfect delivery about tis project.

$80 USD in 2 giorni
(0 Recensioni)
0.0