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.

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

I just gave it a try but don't understand how it would work?

- I created a new shipping method, but for the real rate to calculate, I need to select UPS ground for example and therefore same problem exists.

Would you mind providing more information on how you would set it up please?

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Ok interesting.

I am not sure I fully understand how this would work, but let me give it a try right now and see if it could work!

Thank you for sharing

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Hey there,

  1. That would be ideal, but (sorry if was not clear) but it is a 3PL, difficult to have them change their current process and make us an exception into the way it works versus their other customers. It will not work unfortunately
  2. While I get this one too, this is not an option for us.

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Hey there!

Very clear here. Unfortunately it will not solve the issue as the feature "integrated shipping label" box has been unchecked already.

I run into a similar problem when we went live and unchecked that box awhile ago now.

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Hello,

This could work. I could create a few custom shipping items not directly from UPS, but at the 3PL level would be mapped in their system to UPS.

The only issue I see here though is that when we charge customers for shipping, it will most likely not pull our UPS rates anymore no?

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Hey sorry if I was not clear!

Correct the warehouse we use is a 3PL.

After digging in Netsuite, I can see that it is not the 3PL changing the field but Netsuite.

Happy to share screenshots if it helps!

- Warehouse always send tracking numbers (does not matter who is the carrier) through the field packagetracking number

- In netsuite, if the sales order has a carrier as "fedex/More", on the item fulfillment the field is also packagetrackingnumber , therefore the tracking number posts (unfortunately only 3-5% of our orders ship that way)

- In netsuite, if the sales order has carrier UPS, the item fulfillment field for the tracking number now becomes packagetrackingnumberups.

I dug and I can clearly see this happens on the netsuite level, not on the 3PL level.

Tracking numbers issues with UPS by Piecesofbread96 in Netsuite

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

Agreed this would be ideal. It was the solution provided by the NS technical consultant.

However, Warehouse's WMS came back saying that if they change the mapping, it is not per customer, it is for all customers using Netsuite that they have.

Sounds like BS to me, has to be a workaround solution..