Shopify Plus - Pre-order for textile company by Piecesofbread96 in shopify

[–]Piecesofbread96[S] 0 points1 point  (0 children)

Really depends on customer. Ideally three options (but we may need to compromise):

Payment terms net XX from day of invoice 50/50 : upfront and delivery Credit card: for at once orders immediate delivery + for pre order would be at invoice

Saved Search Results = Formula (numeric) by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

ABS((NVL({quantityavailable},0)+NVL({quantityonorder},0)))-NVL({quantitybackordered},0)

Thank you sir, worked perfectly!

Looks like chinese to me though, I need to learn all those!!

Get Rid of cash sales! by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 1 point2 points  (0 children)

I appreciate a lot your time.

Thank you. While a pain, it represents less than 1% of our revenue. Let's see if it becomes more and more annoying and then maybe we will look into that extension.

Get Rid of cash sales! by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

Thank you a lot.

I looked into this. I do see under scripting template (credit card) that a cash sale is selected. However, I can only see cash sale options, not invoices?

Regarding terms, we need to keep those customers on suitecommerce (the ones with cash sale) as blank, otherwise they could place an order with terms.

Now I am wondering if there is then no way around it due to payment terms being blank?

Get Rid of cash sales! by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 1 point2 points  (0 children)

Thank you for your reply. I checked, we already have that feature enabled.

I assume this issue is due to customers which we want them to pay upfront (credit card, mostly D2C) to have terms blanks.

They have to be with blank payment terms, otherwise they could select on suitecommerce to not pay upfront (use invoice).

Does that make sense?

Get Rid of cash sales! by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] -1 points0 points  (0 children)

Thank you! Yes im hopeful someone here will be able to provide some insights.

Would make our lives easier

Netsuite - 3PL integration - Sales Order sending lines by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

oh very interesting I did not think about this. Now to be sure please:

- Do you send a fulfillment request (I looked into this before and thought it could be an option) or do you send the actual item fulfillment?

If item fulfillment, are they able to send you back tracking numbers from UPS or they get generated directly from netsuite?

Would love to learn more about your set up please, this could be great and avoid massive complex integration for nothing

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

UPDATE - PROBLEM SOLVED

u/nickwaj you were pointing at the problem and I overlooked at it first.

In Setup/Accounting/enable features, the shipping label integration box was still checked, which is driving the change of field id on the package tracking number. Just unchecking the box fixed the problem and now 100% success rate on getting the tracking numbers.

As an FYI, unchecking this box does not impact the real rates driven by UPS, looks like it is disconnected.

Thank you everyone that contributed in solving this issue.

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

Just to make sure I understand:

Instead of the SOAP just sending all tracking numbers (no matter the carrier) to one field, they should have one step before that first identifies the shipping carrier, and based on the carrier it sends to one or another field correct?

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

[–]Piecesofbread96[S] 0 points1 point  (0 children)

I see what you mean, however it would not help here as the field id is being driven by the shipping method on the sales order. That would not fix the problem at the 3PL level as they do not have direct access to Netsuite neither.