DeepSeek Python Script Enhancement
Budget: $30 – $250 AUD
Hi this is the process.
1. we receive invoice for product purhcases - these come from different suppliers
2 we run ai scripts in deepseek, attaching the invoice we received from supplier
3. deepseek produces output from the data in the invoice into format that we use to paste into google spreadsheet. the outputs looks like this file for each respective supplier https://docs.google.com/spreadsheets/d/1lUEjav0eetf-TZMCGeXaJtfBcba3TOOjKCz1aO31Aqw/edit?gid=0#gid=0
4. in the spreadsheet the last two columns are 'compare at price' / image url, 'metafields'. This is where you come in. The python script will extract the Recommended retail price from supersmarkets e.g. Coles, Woolworths, IGA, chemist warehouse. Note that the script will need to be coded using the column 'name' not the column position in the sheet because for each supplier the position for certain columns may change.
5. for the image url, the python script will extract the image of the product put the url link into that column against the respective product
6. the python script captures the respective values for meta fields e.g if the food item is vegan/keto/gluten free etc/ url link and populates the appropriate column in the spreadsheet. 8 we load the spreadsheet into shopify interface
7. after we paste the values into the spreadsheet, we press a button that initiates the python script. free setup such as Google Sheets-triggered execution or a local one-click runner, with no ongoing hosting cost.
2 days to code, 2 days testing, 2 days fix bugs/retest and deploy
1. we receive invoice for product purhcases - these come from different suppliers
2 we run ai scripts in deepseek, attaching the invoice we received from supplier
3. deepseek produces output from the data in the invoice into format that we use to paste into google spreadsheet. the outputs looks like this file for each respective supplier https://docs.google.com/spreadsheets/d/1lUEjav0eetf-TZMCGeXaJtfBcba3TOOjKCz1aO31Aqw/edit?gid=0#gid=0
4. in the spreadsheet the last two columns are 'compare at price' / image url, 'metafields'. This is where you come in. The python script will extract the Recommended retail price from supersmarkets e.g. Coles, Woolworths, IGA, chemist warehouse. Note that the script will need to be coded using the column 'name' not the column position in the sheet because for each supplier the position for certain columns may change.
5. for the image url, the python script will extract the image of the product put the url link into that column against the respective product
6. the python script captures the respective values for meta fields e.g if the food item is vegan/keto/gluten free etc/ url link and populates the appropriate column in the spreadsheet. 8 we load the spreadsheet into shopify interface
7. after we paste the values into the spreadsheet, we press a button that initiates the python script. free setup such as Google Sheets-triggered execution or a local one-click runner, with no ongoing hosting cost.
2 days to code, 2 days testing, 2 days fix bugs/retest and deploy