Magento Automated Script Needed

• Project ID:

  553145

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

I am reposting this project because of confusion over the requirements with the first provider. Please make sure you completely read and understand my requirements.

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 updates. I need a better solution to import daily cost, price and quantity updates to my site.

I have two suppliers that I use – one provides a CSV or XML file and the other provides a .txt file via FTP. I need an AUTOMATED DAILY script developed to pull their data files and import Cost, Price and Quantity to my site. I want the entire process to be automated; from pulling the data files from my suppliers, processing those files to the proper format, and uploading the cost, price, and quantity updates to my site via a script. All of this should happen without any manual work by me.

------------------------------------------------------------------------------------------------

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 also need the product Price to be calculated based on a percentage of Cost.

The Price is to be calculated as a percentage of Cost on multiple tiers as 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 and edit them when I want. Please make sure you understand this.

-----------------------------------------------------------------------------------------------

So based on the information and 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


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. If you have questions about my requirements, please make sure you ask me to clarify.

Thanks!

Skills required:

Magento, PHP, Script Install, SQL