VikG

Hi I want a script that effectively does what my excel spreadsheet is doing which is heavily reliant on Macros. In summary the script needs to: Create a price to sell based on numerous factors and then submit to an external software used which is probably the most complicated part of this. I have the following parts to this: 1. Download latest file sheet from external website (login required) 2. Download our database of SKU and Cost prices from an FTP location 3. The file contains a SKU which is used to establish our cost price. However, the SKU is not identical to our database SKU 4. Using a lookup table and some "find and replace" actions match the SKU from section 1 to SKU in section 2. SKUs that cannot be matched in either of these ways then need to be automatically added to the lookup table and manually filled in with SKUs matching part 2 file. 5. Then using a rate card and some rules I need to calculate the selling price. This will then be sent to the external website as in part 1 in a CSV format. Is anyone able to do something along these lines? Thank you in advance.

Hi Irate, thank you very much. That is also working perfectly,

That worked a treat. Thank you very much kicken. I have noticed a small flaw. If stock level is below 100 it goes minus. Is it possible to set minimum value as 0? Thanks

Hello everyone! I am new here so hopefully I do this right! I have made a PHP script after a lot of google searches to make it work. It works great however I need the following string to show the available stock to be in fact 100 pieces less than it actually is on the xml: $prodarray = "\"$product_record->Product_Code\"".","."$product_record->Available_Stock-48".",All\n"; This will then write to a CSV file for example: "SKU1",500,All This is exported and run on a cron. So instead of 500 I would want it to be 100 units less to 400. How easy is it to do this? TIA