- Original Poster
- #1
Currently What happens:-
Order get placed via a source: telephone, eBay, Amazon etc.
Packaging slip is printed is possible from the website if not one is usually made in word.
These slips then go to "despatch" if you wanna call it, really just 1 person, but let's no go there. He gets product, wraps the product/s, franks it and off it goes.
Area for Improvement:-
In an ideal world, the orders would be entered into a single database that packaging slips would be generated from.
Also in this database EAN and UPC codes for each product we sell would be logged.
In despatch, the order would be on screen, and for the status to be confirmed as Despatched the products EAN or UPC would have to be scanned via barcode scanner to confirm it's the correct product. If the wrong product is scanned, it would come up with an on screen prompt alerting the person of the problem.
The process broken down:-
Order Placed
.CSV Downloaded or Data Exported Somehow
Entered into a Microsoft Access Database or SQL
Packaging Slip Printed
Stage two:-
Order Visible On Screen
Product Barcode Scanned
Barcode checked against Order Details and Product Infomation
All correct barcodes scanned
Despatched Status Logged In Database
I can code reasonably well in VB, and am experianced in Access.
What I am looking for is maybe some advice, links to software that can help me with any stages of development, particually in getting the data from Amazon and eBay.
Thanks,
Matthew
Order get placed via a source: telephone, eBay, Amazon etc.
Packaging slip is printed is possible from the website if not one is usually made in word.
These slips then go to "despatch" if you wanna call it, really just 1 person, but let's no go there. He gets product, wraps the product/s, franks it and off it goes.
Area for Improvement:-
In an ideal world, the orders would be entered into a single database that packaging slips would be generated from.
Also in this database EAN and UPC codes for each product we sell would be logged.
In despatch, the order would be on screen, and for the status to be confirmed as Despatched the products EAN or UPC would have to be scanned via barcode scanner to confirm it's the correct product. If the wrong product is scanned, it would come up with an on screen prompt alerting the person of the problem.
The process broken down:-
Order Placed
.CSV Downloaded or Data Exported Somehow
Entered into a Microsoft Access Database or SQL
Packaging Slip Printed
Stage two:-
Order Visible On Screen
Product Barcode Scanned
Barcode checked against Order Details and Product Infomation
All correct barcodes scanned
Despatched Status Logged In Database
I can code reasonably well in VB, and am experianced in Access.
What I am looking for is maybe some advice, links to software that can help me with any stages of development, particually in getting the data from Amazon and eBay.
Thanks,
Matthew