Greetings, I hope you can help me and thank you very much, I need to go through each record of arrangement 86 and compare it with arrangement 50, you must look for changes in the number of products in an item, which will eliminate the entirety of a product and add new products
Welcome to the Make community!
To allow us to assist you with your scenario, please provide the following:
1. Relevant Screenshots
Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.
2. Scenario Blueprint
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
3. Output Bundles of Modules
Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
Thanks for the recommendations, here I attach the information, My problem is that I don’t know how to go through each array and value to be able to make the comparisons.
blueprint.json (93.6 KB)
You must use data coming out of the Iterator in your filter.
Try this:
Let me know if this is what you were looking to achieve.
Greetings, this is the version I reached, but I don’t know how to compare each record of arrangement 86 with arrangement 50, in this case I am looking to compare the quantities of product x in woocomerce with those of product x in Google Sheet and thus define if it increases the quantity of the product or decreased. I am comparing Product ID Variation ID and if they match I check if I change the quantity, if so I update it in woocommerce.
Thank you so much.
blueprint.json (85.2 KB)
I don’t think it is necessary to create an array of Google Sheet (module 37). Instead add a search criteria of searching for product x inside ‘Search Row Google Sheet (module 37)’.
When Iterator (module 90) is iterating through the array (module 86), it will search for that particular product based on your criteria inside the Google Sheet Search (module 37). In the next step add a filter to allow only records that have a change in quantity.
Your scenario will look like this:
Inside Google Search Rows module:
I think my explanation of the case is bad, sorry, let me explain in more detail, in Woocomerce I have the order registered and in the Google sheet there is the order with the changes, I need to verify what the changes were, such as, I add a product, I delete a product or modify the quantity of a product. The Woocommerce order has 4 Coca-Cola and the Google Sheet order has 9 Coca-Cola. Add the scenario again.
blueprint (1).json (170.8 KB)
I continue with the problem, to compare the array and see the differences