Products - SuperOffice

Fetch products

NSProduct GetProduct(Integer quoteConnectionId, String eRPProductKey)

To call GetProduct(), you need the ID of both the quote connection and of the product itself.

NSQuoteAgent qa;
NSProduct product = qa.GetProduct(1,"3412-20");

NSProduct GetProductFromDbId(Integer productId)

A variant of GetProduct() that lets you retrieve by database ID.

NSQuoteAgent qa;

NSProduct product = qa.GetProductFromDbId(3);

printLine(product.GetName() + "\t" + product.GetCode());

Create product

NSQuoteAgent qa;
NSProduct product = qa.CreateDefaultProduct();

product.SetName("bulb planter");
product.SetERPPriceListKey("5");

product = qa.SaveProduct(product);

printLine(product.GetProductId().toString());

Update product

Fetch the NSProduct object with the agent.
Call the appropriate set methods.
Call SaveProduct().

Delete product

Integer productId = 99;
NSQuoteAgent qa;
qa.DeleteProduct(productId);

Remove from database

Integer productId = 88;
NSQuoteAgent qa;
qa.RemoveProduct(productId);

Reference

Frequently used product fields

Field	Description
product_id	ID
PriceListId	the price list the product belongs to
Name	label for UI
Description
Code	the product code or article number in the product supplier system
PriceUnit	what kind of amount the price pertains to
IsSubscription	whether it’s a recurring offer
Url	link to product information web page
VAT	percentage
UnitListPrice	the basic price from which the discount is computed from
InAssortment	whether currently offered or out-of-stock/discontinued

For a complete list of fields, see the database reference.

Related topics

Product Products Delete Product NSProduct Post Product Default Product

⌘I