3936333 Newbie

Yes you can connect to the SandBox via ODBC. You must point the connection to odbcserver.sandbox.netsuite.com instead of odbcserver.netsuite.com. Driver={NetSuiteODBCDriver};Server=odbcserver.sandbox.netsuite.com;Database=NetSuite.com;Uid=user1@mycompany.com;Pwd=password;

Yes, we have connected using Visual Studio 2005 and SSIS using the new driver. What error are you receiving?

NetSuite doesn't provide CSV imports for inventory adjustments or transfers. However, options involving custom scripting exist. We have developed a SuiteScript solution for a client that allows them to perform physical counting via a wireless scanner. The scanner exports a file that is then uploaded to NetSuite and our…

EasyAsk is a great solution for faceted search and they can provide a great depth of functionality.

It sounds like you would like to create a catalog site in .NET and transfer users over to NetSuite for the shopping cart and checkout. In that case you'll want to look at the WSDK section of the NetSuite help. Web Site--> Web Site Hosting --> Creating An External Catalgo Site (WSDK)

I don't normally post here but I've worked with many NetSuite integrations and I am familiar with the needs of ecommerce sites so I will chime in. 1) Image Zoom: Yes, possible with client-side scripting & JQuery or Flash within the Web Store 2) One page checkout: No. Where is this in the product road map? 3) Yes: There is…

This is all feasible with SuiteScripts and SuiteTalk (Web Services). Most likely, you would want to perform your card authorization via the CC gateway (PayflowPro or others) from the external application and push the created customers and pre-authorized sales orders over to NetSuite. The billing of the sales orders after 7…

Have you tried using the getSelectValue operation?

Campaign responses are not available via SuiteScript. You can create them via web services. You can use the nlapiRequestURL call to the NetSuite web services to accomplish your goal. For an example of how to make a WS call from SuiteScript look here:…

It would be fairly straightforward to accomplish this with a client-side SuiteScript.

For transactions entered via the main NetSuite UI (sales order form), a SuiteScript could be added which will check the payment type. Depending on the payment type, or any other criteria, an additional item can be added to the order with the appropriate amount. If the sales order lines are edited in any way the script…

The eBizNet and SmartTurn products both have integrations to NetSuite. A member of our team led the implementation of eBizNet for his former employer as they converted from a 3PL to an in-house distribution center running on eBizNet. Any WMS worth using will also offer some method of importing or exporting data. Going that…

We have developed solutions to address these shipping limitations for other NetSuite customers. We start with our own customizable NetSuite Shipping Estimator for the shopping cart. We can add any business logic needed to handle complex shipping rules or data from external services (UPS, FedEx, etc) combined with…

We have encountered this problem with several other clients in the past. Unfortunately, there is no access to the password field once the user has submitted the value. In theory, it could be possible to add client-scripting on the sign up pages and capture the password as it is being entered. However, that script would…

There is not much you can do with the customer center on that front.

You can escape the NetSuite's default table format and div/css positioning instead. It is a little tricky but we consider it the best practice for NetSuite Web Store development.

Aliafshar, thank you for the compliment on the site. Our team is proud of the effort they put into on 1800healthy.com.

We just launched a new, highly customized, NetSuite Web Store for a client, 1800healthy.com, that is using a content delivery network to host the majority of images, css, and JavaScript files. We have seen load times improve by over 50% by moving those files off of NetSuite. That hasn't fully cured performance issues. Our…

There is not built-in functionality to access the cart contents. However, by adding scripting to the shopping cart you can parse the cart HTML to gather the contents and then store those values in NetSuite. The customer will need to have registered and be logged in.

If you deactivate the built-in NetSuite confirmation email and then develop a custom confirmation email via SuiteScripting you can have full control over the content of the email. That will allow any customer, item, or order fields to be sent including the message and gift wrap selection mentioned.

To expand on the last post, if you add a server-side script that is triggered during the customer registration process you can automatically assign them terms which will allow a new customer to be presented a "Pay by Check/Wire Transfer/Call..." option. If sales orders are approved by default you need to also add another…

We have written scripts for several of our clients that restrict the visible shipping methods. A common situation is for orders with shipping addresses outside the lower-48 states. The full set of shipping options is restricted via scripting so that only the appropriate options are displayed.

RESTLets will definitely provide much better performance than the Web Services API calls. If you are using a standard NetSuite user to make you Web Services calls, you will only be able to make once connection at a time. You need to upgrade to the special NetSuite Web Services Concurrent User to make multiple concurrent…

It looks like you are performing a search against the custom records, retrieving the returned list or matches, iterating across the returned list, updating a field, and then sending the custom record object (cr) back up via the update method. You will generally find that the objects returned from a get or search call…

JSchneller - What is your standard for "quick in production"? When we work with clients and design solutions for them we generally recommend that they use NetSuite Web Services for off-line synchronization of data and that the web application communicates with this synchronized database. This is especially true in an…

We often seen those types of response times or longer with our clients' Sandbox accounts.

That code looks fine. Double-check that you have the correct external invoice and that it is indeed an invoice record.

If you are working with certain transactions you can use the toBeEmailed and email fields. If you set the toBeEmailed to true upon creation or via an edit the record will be emailed. We have also created numerous solutions that provide custom email functionality from SuiteScript within NetSuite or outside via a custom…

If you want to search a range you need to use SearchDateFieldOperator.within. Only the within or notWithin operators use the searchValue2 field. All of the other operators reference the searchValue field only.

Your search criteria aren't matching any items. As JChernia suggested, you need to probably remove the search on the itemId. <platformCommon:itemId operator="startsWith"> <platformCore:searchValue>10</platformCore:searchValue> </platformCommon:itemId> <platformCommon:price operator="greaterThan">…