user10648298 Newbie

Thanks Brion, it's good to hear when things go well. I don't totally understand your second question. I don't think you can update the quantity on hand once the item was created. If the wholesale and retail items are different items, you can use separate units of measure, but as I say I'm not sure what problem you are…

It looks like you've mapped your Price column to Price Level. Retry and map this column to "Price" and then pick a default for "Price Level" (click the pencil and pick a default value (eg "Base Price")). -John

For a Scheduled SuiteScript example, see page 49 of the developer guide. The first part of that script is a search. https://system.netsuite.com/help/helpcenter/en_US/PDF/SuiteScriptDeveloperGuide.pdf?NS_VER=2007.1.0 -John

This is Issue 132921, it has been fixed and it scheduled for relase tonight. You should be able to import tomorrow. -John

Please file a case, post the number and we will investigate. Your steps seem correct. -John

There are two ways to do this 1) Saved Search / Custom Labels *Create a saved search for items *Go to the results tab and pick your pricing columns *Change the "custom label" of these fields to "Price Level:Online Price" (or Base Price, etc - no space after the colon). *Save the search and export the results to CSV. *You…

This is now tracked by issue 132972. Note that only Multi-File imports should have a mapping folder for Contact Addressbok. -John

INS, is this for single file or multi-file Prospects and Contacts? -John

Please file a case with support and post the number. -John

I believe the Celigo tool uses WebServices via an Excel/VB plug-in. This is a good strategy, and a good example of what we hoped partners would do with WebServices. I have not used this tool, and don't mean to directly endorse it, but it looks like a promising way to get transactions into your system via CSV for now. -John

Please file a case with the XML file that is causing the error (preferably the smallest one that will cause it). It means that an uncategorizeable error happened in NetSuite (thuse the vagueness). -John

If you select "sales rep" from the NetSuite fields and bring up default options (the pencil icon) then "set field to null value" should remove the sales rep for you. -John

To add to what Elliot said, if you use the template style column headers for pricing, eg Price Level:Base Price The assistant should automatically map your price levels correctly as multiple columns. Here is some more information on Item Imports. https://usergroup.netsuite.com/users/showthread.php?t=7051 -John

Multi-Location support is in the 2007.1 release for CSV. Your options until then are SMBXML or Web Services. -John

Make sure you have the capitalization exactly correct. That's probably it. To check, go to a New Item form and look at the "Item Display Image" dropdown. -John

You can export the list of 5000 internalIds and the COGS Account (using saved search). Modify the COGS account column in Excel. You can then re-import this file with just internalId and COGS Account as columns. That is probably the easiest way. -John

Yes, multiple currencies, quantities and prices are available.

It's a shot in the dark but when you tried the i:71132 were you logged into NetSuite with the role "NetSuite, Inc. - Customer Center"? If not you have to be. -John

If you can construct a saved search that retrieves the information you want, you can export to CSV/Excel from there. -John

Good point, I was thinking of something more like WebServices where you could change your program to update a CustomRecord from the same data source when updating the price levels vs accessing the item record. Speaking of WebServices, you could do it that way. Simply perform a get() on an item and you will get its…

Olivier is correct, what I suggested requires either a program a partner has written or writing one yourself. I thought I would put it out there as a workaround until we enhance CSV export. -John

This thread probably belongs in the Web Site / E-Commerce forum (this is Import / Export ) https://usergroup.netsuite.com/users/forumdisplay.php?f=20 It's a good question though. -John

One solution, albeit not a great one, is to create a custom record that has as fields each of the quantity breaks/price amounts. You should also have a field that references the item and the customer. You can then build searches/reports off of that custom record. The downside is that you have to make sure you update your…

Also, once you are upgraded to 2007, you should be able to import customers and give them access. In addition to username/password/give access they will need a role (eg Customer Center).

Type i:71132 into the global search box and press return. It should take you right there. -John

Via Web Services you can, and via SmbXml you can. Have you looked at the SMBXML DTD or the Web Services wsdl? -John

Yes, lots. Here is the developer page on WebServices: http://www.netsuite.com/portal/developers/resources/suitetalk.shtml Here is the HTML version of the documentation - http://www.netsuite.com/portal/partners/integration/WebServicesHelp/Output/wwhelp/wwhimpl/js/html/wwhelp.htm there isn't a deep link, so go to…

It sounds like what you want is to update the "Item Pricing" subtab on the customer if the prices are really unique per customer. If there are a lot of commonalities and multiple customers use the same prices, then you'd setup a price level (which sounds similar to a price sheet). I may be misunderstanding. Your use case…

You can add a price level that is discount based and then make that the default price level for that customer. I would advise against creating one price level per customer (instead create a bunch of discount levels). To set the customer's default price level go to the customer record->Financial Tab->Item Pricing Subtab.…

You should be able to update all pricing information for an item in CSV at this point. If you choose "update" (not add or update), and map a key as well as the pricing fields, it should just update. You shouldn't need to re-enter (or map) the tax codes for an update via CSV. This is new as of the 2007 release. -John