Help

SCRIPT

Topic Labels: Automations
159 3
cancel
Showing results for 
Search instead for 
Did you mean: 
PGD
4 - Data Explorer
4 - Data Explorer

Hi , all

I have a problem that I can't solve, I have a script that updates the prices and countries of my products based on a code for example
The problem is the following if two products have the same code then it modifies both. To solve this I thought in the following way each product is linked to a unique supplier so I just need to retrieve all the suppliers displayed to my user so that he chooses the right one and I would only update the products from this supplier while always comparing if the code is the same.

I manage to retrieve the suppliers but I cannot update the products afterwards

Would anyone have an idea?

3 Replies 3

Could you provide screenshots of your data, the script itself, and an example of what your input and output would be?

Hi, 

So finally I compare the product table and product import on a specific column for example supplier code and I update accordingly.

F1, F2 = Script

 

 

Hmm could you provide access to a base with the script set up?  That would allow people to help you immediately without needing to type out your code or recreate your base structure

If you're not too familiar with scripting I'd suggest trying to do this with an automation instead too; that's a fair amount of code to go through and I don't know if you'll be able to find someone to help you review it