Forum in maintenance, we will back soon 🙂
Hi Hasan,
I have a challenge for you which i am sure you would be able to solve for me and i know it would be so useful for a lot of other people who use Woocommerce or are learning Python.
So i run a Woocommerce store and i had a brick wall i had to over come. So i though i'd ask ChatGPT if there was a way to solve my issue.
Here is my question and the answer i got back from ChatGPT:-
ChatGPT
Would you be able to create a video that would take this problem and use the instructions provided by ChatGPT and show us how we can make this solution work?
I think that would be a great project for us to learn from.
Thanks in advance Hasan @admin
@rajsidhu you need a dedicated server to process the data like this. The amount of data can quickly overwhelm any VPS. There are also a lot of DevOps that you also need to consider.
Regards,
Earnie Boyd, CEO
Seasoned Solutions Advisor LLC
Schedule 1-on-1 help
Join me on Slack
so you need to fetch the data from the target server and then update woocommerce; this definitely needs a custom solution and custom coding, I don't think there is an automated no code approach
you will need to read the CSV, and using the woocommerce hooks and functions, you will update the products.
can you send like 5-10 records of the CSV to see how it is structured?
And it's very much dependent on the data service provider; so you need custom code for each different service provider.
Regards,
Earnie Boyd, CEO
Seasoned Solutions Advisor LLC
Schedule 1-on-1 help
Join me on Slack
@admin Here is an Excel spreadsheet that contains the structure of the products to be uploaded.
Once they are uploaded, the products will be available to buy on our Woocommerce website.
But every day this file will be update with stock and any price updates so the automation will be just for the updated info. coming through every day.
Hope that makes sense.
@rajsidhu is it always going to be this one sheet? If so, then this would be a good fit for automation tools like Make.
Regards,
Earnie Boyd, CEO
Seasoned Solutions Advisor LLC
Schedule 1-on-1 help
Join me on Slack
@rajsidhu yeah as @ssadvisor mentioned, you can use no code automation tools like Make to read and update the woocomerce products.
I don’t know if woocommerce have all the endpoints to do so. But anyway, it is not so complicated.
@ssadvisor So the csv that contains the updated information is always going to be the same file name and location. It just get updated with new stock levels and prices (if they change that is).
What do you think?
@rajsidhu yes, definitely doable with Make. Try it and if you need help add SSAdvisor as a team member for me to take a look.
Regards,
Earnie Boyd, CEO
Seasoned Solutions Advisor LLC
Schedule 1-on-1 help
Join me on Slack
@ssadvisor @admin How would i start to create this automation, Can you advise please?
@rajsidhu start here https://staging.learnwithhasan.com/no-code-ai-system-topic-research/
Regards,
Earnie Boyd, CEO
Seasoned Solutions Advisor LLC
Schedule 1-on-1 help
Join me on Slack
@ssadvisor @admin not sure how this will work for me.
I want to create an automation that will update prices and stock for products in my Woocommerce store.
Friend, sorry, but how can we help here?
you can use Make to do this with no code, try it, and we will help.
@rajsidhu Try building the foundation yourself and if you faced problems we can help you in this thread.