I want to make a csv import to change some product...
# ask-stanley-ai
l
I want to make a csv import to change some products, I want to change the "vendor code" for an specific vendor in the "itemvendor" sublist, how should I make the import to change the vendor code for the vendor that I want and the other one just leave it as is. I'm basing my csv in the result of a saved search that has: internal id of the product, name, vendor code and vendor as columns, I have more than one results for each item because the same item has several vendor and vendor code.
c
AI generated answer (using internal Slack threads):
To change the "vendor code" for a specific vendor in the "itemvendor" sublist, you can use the CSV import feature in NetSuite. Here are the steps: 1. Go to Setup > Import/Export > Import CSV Records. 2. Choose the record type as Items. 3. Choose the import type as Update. 4. Upload your CSV file. The CSV file should have the following columns: internal id of the product, name, vendor code, and vendor. Make sure the vendor code column has the new vendor codes for the specific vendor you want to change, and the same vendor codes for the vendors you want to leave as is. 5. In the mapping step, map the CSV columns to the corresponding NetSuite fields. The "vendor code" should be mapped to the "Vendor Code" field in the "Item Vendor" sublist. 6. In the options step, check the "Overwrite Sublists" option. This will ensure that the vendor codes for the specific vendor are updated, while the vendor codes for the other vendors are left as is. 7. Click Next and then Finish to start the import. Please note that the "Overwrite Sublists" option will overwrite all the sublist lines for each item with the sublist lines in the CSV file. So, if an item has multiple vendors and only one of them is included in the CSV file, the other vendors will be removed from the item in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847149849
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846833408
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846410036
Please provide your feedback on this answer.