Project Detail

Description

I have approximately 16,000 products in my Magento store. The built-in Magento CSV Import function is very slow and takes about one day to import all price and quantity changes. I need a better solution to import daily price and quantity updates to my site. I have two suppliers that I use and they provide a CSV data file via FTP. I need a daily script developed to pull their data files and import Cost, Price and Quantity to my site.

So, for example, the following is the type of data that I get from my suppliers (each supplier has a slightly different data file):

SKU Cost MAP Qty
12345 $50.00 $65.00 7
12121 $100.01 5
34343 $200.00 0
35474 $5000.00 $6100.00 12

I need the above data to be imported to my site daily. I also need the product Price to be calculated based on a percentage of Cost and also imported.

The Price to be calculated as a percentage of Cost on multiple tiers is shown below:

If Cost = $0 to $10.00 then Price = Cost x 1.20
If Cost = $10.01 to $20.00 then Price = Cost x 1.15
If Cost = $20.01 to $50.00 then Price = Cost x 1.12
If Cost = $50.01 to $100.00 then Price = Cost x 1.10
If Cost = $100.01 to $250.00 then Price = Cost x 1.08
If Cost = $250.01 to $500.00 then Price = Cost x 1.07
If Cost = $500.01 to $2000.00 then Price = Cost x 1.06
If Cost = $2000.01 or more then Price = Cost x 1.05

I need to be able to set up these above tier values and percentages somewhere in the backend so that I can change them if I want.

So based on the formulas above, the import data would look like this:

SKU Cost MAP Price Qty
12345 $50.00 $65.00 $56.00 7
12121 $100.01 $108.01 5
34343 $200.00 $216.00 0
35474 $5000.00 $6100.00 $5250.00 12


Based on this information, I would like to know if my requirements are possible to develop. I also need to know how long the script would run to import to my site.

I am looking for an experienced Magento developer, preferably one that has performed a similar script as I’m looking for. Please let me know your cost and when you can get started and how long it would take to complete.

Thanks!