En cours

Automate Data Entry in Macro Scheduler

I am looking to take a CSV file containing [url removed, login to view] orders, store its contents in a database, and enter the data into an application (client server app).

There are few more details because there will be com logic that needs to be programmed, as well as some error handling.

DATABASE TABLES NEEDED FOR PROJECT:
1. PRODUCT_MASTERLIST - Lookup table that we create to determine product associations. AMAZON uses a different SKU than what we use in our in-house inventory database.
columns: AMAZON_MODEL_NUM OUR_MODEL_NUM
model_abc (new) model_abcGX
model_abc (new) model_abcNB
model_xyz model_xyz
model_123 model_123GB
2. ORDERS - All orders will be stored in this table. Data will come from Amazon and consist of all orders for the day.
columns: ORDER_NUM, AMAZON_MODEL_NUM, QUANTITY, PRICE, SHIPPING_FEE, etc

WORKFLOW PROCESS

1. EMPLOYEE will download our "unshipped" orders from Amazon for the day in a CSV file to our local PC (manually). ie: Source File "Spreadsheet1.csv"
2. MACRO will import all the data in the Source File into a MySQL database table (store on a webserver).
- software should check to ensure the "order number" does not already exist in the database before updating the table. ORDER NUMBER is a column in the Source File, and will be used as a unique identifier in the table. We will append data here each day
3. MACRO will take specific columns from the database table and create a new CSV file containing a subset of the data from the Source File. SAVE FILE "Spreadsheet2.csv"
4. EMPLOYEE will manually update the new "Spreadsheet2.csv" file (excel) with the shipping data for each order and save the document (save to local directory)
5. MACRO will input data from the "Spreadsheet2.csv" and enter it into our inventory system. It has to be a front end entry because we dont have direct access to the application database.
- software will create a new invoice. This will open a new screen and generate a new invoice number
- software will enter all the necessary data from the spreadsheet.
- when software is entering the model number into the inventory system, the system will take the AMAZON_MODEL_NUM from the spreadsheet and do a lookup in the PRODUCT_MASTERLIST to determine what the item is called in our inventory system (the OUR_MODEL_NUM column).
- software will enter our model number into the inventory system, the quantity, the shipping price, and the price
- software will give exception report if quantity is not available. If customer orders 10 items, and there are only 6 in stock. Software should log the exceptoin and continue to next row in spreadsheet. An exception report will be generated at the end of the process (all exceptions listed here for the day)
- software will check to ensure the the totals match. INVENTORY SYSTEM TOTAL ORDER AMOUNT = SPREADSHEET TOTAL AMOUNT

6. MACRO will take the invoice number from the Inventory App, and put it in the INVOICE NUMBER column in "Spreadsheet2.csv". SAVE FILE

Right now I am looking to use Macro Scheduler software to develop this app. Looking forward to hearing from you.

Barry
323,360.1458

Compétences : Programmation C, Visual Basic

Voir plus : automate data entry csv, Programming Logic, data entry macro, data entry error, data entry database software, data entry application software, database entry software, c scheduler, data handling, amazon data entry , error macro, csv file amazon, enter data app, automate data entry, scheduler application, programming scheduler, macro data entry, amazon macro, enter data server, data entry client details, csv amazon, amazon store csv, orders data entry, app data entry, data entry csv file

Concernant l'employeur :
( 1 commentaire ) Woodland Hills, United States

N° du projet : #2398543

Décerné à :

xaptor

howdy, can you send me more details please?

250 $ USD en 7 jours
(1 Commentaire)
2.8

10 freelance ont fait une offre moyenne de 365 $ pour ce travail

ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

250 $ USD en 3 jours
(106 Commentaires)
6.3
Rahul2012

Please check your PM.

250 $ USD en 4 jours
(17 Commentaires)
5.0
valleysoftware

"Please see PMB"

250 $ USD en 3 jours
(5 Commentaires)
3.6
ednriu

Sir, I am experienced programmer. Please contact me if success is important for You.

500 $ USD en 7 jours
(1 Commentaire)
2.3
esalem

Hello, please see the PM for details.

500 $ USD en 10 jours
(1 Commentaire)
1.0
gjinfotech004

Please check inbox ...........

250 $ USD en 5 jours
(0 Commentaires)
0.0
Tuxxin

I work hard to make sure my clients are happy and the project is done correctly. I'm available immediately to get this project completed for you quickly. Check my profile for my background information.

350 $ USD en 3 jours
(0 Commentaires)
0.0
seekdeveloper

Hi, Kindly check PMB

750 $ USD en 8 jours
(0 Commentaires)
0.0
tedtally

Barry, I have over a decade of experience dealing with Microsoft technologies. It would be great to work for you on this project.

300 $ USD en 7 jours
(0 Commentaires)
0.0