2024.1 Order Settings

2024.1 Order Settings

This section contains general Order Export settings.


Configuration nameExample valueDescription
Default order status

Select

Sets the NetSuite Sales Order Status that will be the default status after an Order Export to NetSuite. It can be changed depending on the project requirements and client workflow.

Possible values:

  • pendingApproval
  • pendingFulfillment
Location IdIntegerInternal Id for the Order Export usage. It can be the same or differ from the Stock Location - 2024.1 Stock Options.
Custom fields that are to be synched between Magento and NetSuiteTable

Sales Order Fields mapping for Order Export.

  • NetSuite field name - the field name as defined in NetSuite. Must be defined at the Sales Order level.
  • NetSuite field type:
    • custom field - simple: any field of a simple type, i.e. string, text area, number, date etc.
    • custom field list: field with a list style.
    • standard: a standard order field. The list of possible standard fields can be found in the SuiteTalk documentation.
    • standard record ref: an order RecordRef field type. This feature allows mapping to select from NetSuite options with fixed or order values in Magento. The value that will be sent should be the same as a NetSuite option's internalId. More can be found in the SuiteTalk documentation.
  • NetSuite list internal id: the internal id of the list, and in this case, the type of the field is a list type. Leave it empty otherwise.
  • Value type:
    • Magento order attribute - whether or not a value will be passed is an attribute of the Magento order object.
    • Fixed value: pass the value exactly as defined in the text field. Usecase: always pass the value of "Magento" to a "channel" field.
  • Value: If the value type is fixed, the value here will be passed as is with the order. If the value type is "Magento order attribute", then you need to pass the attribute exactly as it appears as a column name in the sales_flat_order table.
Default discount item internal idIntegerThe Internal Id of a Non-Inventory Item that is used for exporting the Discount amount. It is a line item containing the discount (entire order). There is no default way to have different types of discounts. See how to create a discount item below.
Select Where to Export the DiscountSelect

Set one of 2 types of Discount Export strategies:

  1. "Adding Discount to Item List"
  2. "Using Discount Item Field"

If the "Adding Discount to Item List" is chosen - there will be an added separate discount item with the sum of all Discounts in the Magento Order.

If the field "Using Discount Item Field" is chosen - discounts will be added to the Sales Order Body.

Add Discount Per ItemBoolean

This configuration is visible only if "Adding Discount to Item List" is chosen as an export strategy (see config: Select Where to Export the Discount).

If it is enabled, the NetSuite Connector adds a separate discount item to the sales order per discount in magento order. If the configuration is disabled - all Magento Order Discounts will be summed up and added as one Discount Item.

Add Promotion Data for each Item BooleanRocketWeb Magento 2 Discount bundle adds two custom columns on SalesOrder to ItemList which are used for better Discount reporting. If you have the Bundle installed and you want to use this, set it to Yes.
Status MappingTableA Magento to NetSuite (and vice-versa) status mapping should be defined. Every status change in NetSuite will update the status in Magento according to this map. Note that this does not work the other way around, though: only the initial status in Magento will be pushed to NetSuite according to the map, all other status changes in Magento will be ignored, as it is assumed all order processing is done in NetSuite.
Enable Payments as NetSuite TermsBoolean

Enabling this will mark "Payment on Account" and "Purchase Order" payment methods in Magento as NetSuite Terms payments when creating a Sales Order in NetSuite. This setting also enables NetSuite Invoices import for orders exported to NetSuite with payment terms. See: [techflow][b2b] NetSuite Invoice Import from NetSuite

Discount Item Creation

  1. Navigate to NetSuite
  2. Go to go to Lists →  Accounting → Items → New
  3. On the next page press on Discount
  4. Fill in the required fields to create a 0.00 Discount Item
  5. Note its Internal Id after saving (it is the number in the URL)