I am trying to import sales order from magento to ...
# suitescripta
Ahmed
01/01/2020, 12:56 PMI am trying to import sales order from magento to netsuite .. Problem is that i am successfully able to pull out sales order but the shipping address [Ship To] address is not imported Instead the default address saved for the customer is selected as the ship to address for the sales order.
var salesOrder = record.create({
type: record.Type.SALES_ORDER,
isDynamic: true,
});
var subrec = salesOrder.getSubrecord({
fieldId: 'shippingaddress'
});
addr1 = "Street, "+data["shipping_address"]["street"]["#text"];
subrec.setValue({ fieldId: 'addr1', value: addr1 });
subrec.setValue({ fieldId: 'city', value: data["shipping_address"]["city"]["#text"] });
subrec.setValue({ fieldId: 'state', value: data["shipping_address"]["region"]["#text"] });
subrec.setValue({ fieldId: 'zip', value: data["shipping_address"]["postcode"]["#text"] });
subrec.setValue({ fieldId: 'country', value: data["shipping_address"]["country_id"]["#text"] });
subrec.setValue({ fieldId: 'addressee', value: data["customer_firstname"]["#text"]+' '+data["customer_lastname"]["#text"] });
subrec.setValue({ fieldId: 'attention', value: data["customer_firstname"]["#text"] });
b
battk
01/01/2020, 12:59 PMfor dynamic mode the order fields are set matters
battk
01/01/2020, 12:59 PMdo you set the address first or the customer
a
Ahmed
01/01/2020, 1:05 PMcustomer
Ahmed
01/01/2020, 1:08 PMShall i set customer after the shipping address?
b
battk
01/01/2020, 1:11 PMcustomer first
battk
01/01/2020, 1:12 PMthe general idea is to set the fields in the same order you would in the ui
a
Ahmed
01/01/2020, 1:14 PMi tried that as well .. but issue was still there ..
Ahmed
01/01/2020, 1:15 PMFor the customer that exists in Netsuite ., Magento address is ignored and the already saved address is put in the shipping address ship to field
Ahmed
01/01/2020, 1:15 PMAm i missing something in the code
b
battk
01/01/2020, 1:15 PMyou can try setting country first
a
Ahmed
01/01/2020, 1:19 PMTried that .. same issue .. shipaddresslist ..
Ahmed
01/01/2020, 1:20 PMshipaddresslist
Select the appropriate shipping address for this transaction. * Select New to enter a new shipping address to be used for this transaction and saved with the associated entity record. * Select Custom to enter a new shipping address to be used for this transaction only (and not saved with the associated entity record). * Click the Edit icon to edit an existing shipping address.
Ahmed
01/01/2020, 1:20 PMFound this on the record browser .. can my issue resolve by using this key "shipaddresslist" . Do you knwo how to use this
b
battk
01/01/2020, 1:24 PMits not supposed to
battk
01/01/2020, 1:32 PMis the address subrecord incorrect
battk
01/01/2020, 1:33 PMor is only the shipaddress text box wrong
a
Ahmed
01/01/2020, 2:00 PMshipaddress only
Ahmed
01/01/2020, 2:00 PMOnly the Ship Address is wrong which comes under Ship To label
b
battk
01/01/2020, 2:02 PMdont use dynamic mode
battk
01/01/2020, 2:03 PMor overwrite the shipaddress field with the addrtext from the subrecord
a
Ahmed
01/01/2020, 3:30 PMit still doesnt work.. showing default address
b
battk
01/01/2020, 3:56 PMif you are using dynamic mode, share how (and where) you overwrote the shipaddress
battk
01/01/2020, 3:56 PMif you arent using dynamic mode, share your new code
a
Atiq Rehman
01/01/2020, 6:26 PMUsing dynamic mode:
var salesOrder = record.create({
type: record.Type.SALES_ORDER,
isDynamic: true,
});
var subrec = salesOrder.removeSubrecord({
fieldId: 'shippingaddress'
});
var subrec = salesOrder.getSubrecord({
fieldId: 'shippingaddress'
});
addr1 = "Street, "+data["shipping_address"]["street"]["#text"];
subrec.setValue({ fieldId: 'addr1', value: addr1 });
subrec.setValue({ fieldId: 'city', value: data["shipping_address"]["city"]["#text"] });
subrec.setValue({ fieldId: 'state', value: data["shipping_address"]["region"]["#text"] });
subrec.setValue({ fieldId: 'zip', value: data["shipping_address"]["postcode"]["#text"] });
subrec.setValue({ fieldId: 'country', value: data["shipping_address"]["country_id"]["#text"] });
subrec.setValue({ fieldId: 'addressee', value: data["customer_firstname"]["#text"]+' '+data["customer_lastname"]["#text"] });
subrec.setValue({ fieldId: 'attention', value: data["customer_firstname"]["#text"] });
Atiq Rehman
01/01/2020, 6:27 PMBut still shows the default shipping address of the customer in order shipping address.
Atiq Rehman
01/01/2020, 7:00 PMsalesOrder.setValue({ fieldId: 'shipaddresslist', value: null });
Seems like this line did the trick, will test more
g
george085
01/01/2020, 10:32 PMI set shipaddresslist to null, works for me
george085
01/01/2020, 10:34 PMsalesOrder.setValue({
fieldId: 'shipaddresslist',
value: null
});
var shippingAddressRecord = salesOrder.getSubrecord('shippingaddress');
var shippingAddressDetails = this.getAddressDetails(order.shipping_address, shipPhone);
util.each(shippingAddressDetails, function(v, k) {
shippingAddressRecord.setValue({
fieldId: k,
value: v
});
return true;
})
george085
01/01/2020, 10:35 PMin dynamic mode of cause, and it creates custom address record, tested and bullet approve
2 Views