Suljettu

Inventory automation

Objectives of the project – To create an MS Access database that will handle multiple distributor inventory files from the source into a series of files for daily upload into our Ebay Prostore and our oscommerce site with as much automation as humanly possible. We are open to suggestions to getting to the intended end result.

Ebay Prostore project

1. Create multi-distributor inventory Access database.

2. Ftp automation - pick-up various distributor feeds for timed nightly download using CuteFtp

3. Automate application of specific pricing formula to downloaded inventory files saving results to Access database. Open to other ideas to getting to the same end. (See [url removed, login to view] and [url removed, login to view]) Note: the price is adjusted to the desired result in the sample distributor feed

4. batch import the edited inventory files into distributor inventory Access database

5. Create Access database query that will filter and not post items that are not in stock to the Ebay Prostore.

6. Create Access database query that will filter products from all distributors accounting for all duplicate products and only posting the lowest price product from any given distributor to the final upload files.

7. Save files into ftp manageable sizes for upload to Ebay Prostore format

8. Upload initial feeds with all product data fields. Set daily upload file to only upload inventory balances and any prices changes to the ecommerce tables. If a product has a zero quantity in file have the entire product record inactive from the Ebay Prostore.

OsCommerce project

9. Automate application of specific pricing formula to downloaded inventory files saving results to Access database. Open to other ideas to getting to the same end. (See [url removed, login to view])

10. batch import the edited inventory files into distributor inventory Access database

11. Create Access database query that will filter and not post items that are not in stock to the OsCommerce store.

12. Create Access database query that will filter products from all distributors accounting for all duplicate products and only posting the lowest price product from any given distributor to the final upload file.

13. Save files into ftp manageable sizes for upload into OsCommerce format

14. Upload initial feeds with all product data fields. Set daily upload file to only upload inventory balances and any prices changes to the ecommerce tables. If a product has a zero quantity in file have the entire product record inactive from the OsCommerce.

Any additional input on the project would be appreciated.

Taidot: C-ohjelmointi, PHP, Komentosarjan asennus, Visual Basic, XML

Näytä lisää: series application, posting accounting, open source ecommerce project, format pricing, format prices, ebay store feed, zero accounting, ebay store prices, timed, product inventory, inventory database, input products, ideas stock, ebay file upload, distributors, distributor, desired, c automation, automation project , automation c, database import filter, import access database php, saving products, ebay csv file upload, automate ecommerce inventory

About the Employer:
( 0 reviews ) Syracuse, United States

Projektin tunnus: #48164

12 freelanceria on tarjonnut keskimäärin 224 $ tähän työhön

cstl

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development Lisää

240 $ USD 10 päivässä
(21 arvostelua)
6.9
websoftinfo

Our bid is for really very high quality work for your Inventory automation that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes six wee Lisää

300 $ USD 10 päivässä
(68 arvostelua)
6.5
outsourcevn

Our Company is a Global Provider of security solutions, software, data backup, and various IT services including Web development and search engine optimization. Our 20 employees bring years of experience in software de Lisää

300 $ USD 30 päivässä
(1 arvostelu)
4.5
abhijitcari

We are working with Access & VB for the past 6 years. We have also developed many important application using MS-Access as both front-end and back-end tool. It's our passion to do programming and we could even comprom Lisää

100 $ USD 20 päivässä
(6 arvostelua)
3.3
amanullahs

I can write a decent MS Access app/db for your requirement. I do have experience on similar requests. Trust me, my expertise is Access VBA.

300 $ USD 15 päivässä
(1 arvostelu)
2.7
visasoftwares

VisaSoft is a customer-specific service oriented company has got an Professional and creative team.We are the Professional Web Development Company having 3 years experience in Web design and development. We have expe Lisää

100 $ USD 10 päivässä
(1 arvostelu)
2.4
ijack

high price high work belive in best, regards jack

300 $ USD 1 päivässä
(0 arvostelua)
0.0
gcsdelhi

finest developers with highly satisfied clients give us a chance for giving you the best we trust in building long term relations with clients to serve them the best

200 $ USD 5 päivässä
(0 arvostelua)
0.0
yoursam2001

Dear sir , we are growing company with good products and efficient Team.I want to assure you about the quality , perfection and professionalism of the work.We believe in best so i am bidding on a best cost which is im Lisää

300 $ USD 46 päivässä
(0 arvostelua)
0.0
snehalds

Dear Sir, We have provided such kind of facility to one of our clients in India. The Client is a reputed MNC based in India. We can easily meet your requirement and have confidence for completing the project. Lisää

225 $ USD 15 päivässä
(0 arvostelua)
0.0
maheshsayani

Hi sir, We have good team to complete the task with quality output. we already worked with the similar project as your requirement. please see PM for more details regards Mahesh

220 $ USD 10 päivässä
(0 arvostelua)
0.0
RajeevaSingh

We are working with Access & VB for the past 3 years. We have also developed many important application using MS-Access as both front-end and back-end tool. It's our passion to do programming and we could even compromi Lisää

101 $ USD 10 päivässä
(0 arvostelua)
0.0