Encerrado

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.

Habilidades: Programação C, PHP, Instalação de Script, Visual Basic, XML

Ver mais: series 7 application, posting in accounting, open source ecommerce project, ms project product, ms access ebay, lowest lowest, import ms project, format pricing, format prices, ebay store feed, zero accounting, set up ebay store, ms project price, ebay store prices, create an ebay store, timed, product inventory, inventory database, inventory & accounting, input products, ideas stock, ebay file upload, distributors, distributor, desired

Acerca do Empregador:
( 0 comentários ) Syracuse, United States

ID do Projeto: #48164

12 freelancers are bidding on average $224 for this job

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 Mais

$240 USD in 10 dias
(21 Comentários)
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 Mais

$300 USD in 10 dias
(68 Comentários)
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 Mais

$300 USD in 30 dias
(1 Comentário)
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 Mais

$100 USD in 20 dias
(6 Comentários)
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 in 15 dias
(1 Comentário)
2.7
visasoftwares

VisaSoft is a customer-specific service oriented company has got an Professional and creative [url removed, login to view] are the Professional Web Development Company having 3 years experience in Web design and development. We have expe Mais

$100 USD in 10 dias
(1 Comentário)
2.4
ijack

high price high work belive in best, regards jack

$300 USD em 1 dia
(0 Comentários)
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 in 5 dias
(0 Comentários)
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 [url removed, login to view] believe in best so i am bidding on a best cost which is im Mais

$300 USD in 46 dias
(0 Comentários)
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. Mais

$225 USD in 15 dias
(0 Comentários)
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 in 10 dias
(0 Comentários)
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 Mais

$101 USD in 10 dias
(0 Comentários)
0.0