Hi Vince,

We are using the built in ShipStation feature which great but noticed the option weights do not seem to be multiplying up the same as the base product when they get imported.

Our weight is set to KGS in the ECT main settings and on an our most recent customer order the product base weight is set to 0.14.

On our products we use dependent options and on this particular order the customer selected a dependent option with a Weight Diff of 0.082 making a total weight of 0.222Kg or 222g.

On the order itself it shows a weight of 0.2 in our ECT admin which is correct but when it's imported into ShipStation the weight shows as 140.08 grams.

From what I can tell it's multiplying the base weight of 0.14Kg by 1000 to get the 140g but then just adding on the option weight of 0.08 to get 140.08 when it should be 222g.

The main issue of course is that it means the automation rules for what shipping to apply are incorrect for some orders.

Is there anything that can be done to add in the option weight (if there is one) before multiplying by 1000 to convert to grams?

Regards,
David

Hi David, while I can't answer your question directly, I wanted to lay out what we do.
Too often, due to the box and packing material weight, the weights from the store do not match the actual package weights.
What we did was in Ship station, (it's possible to setup all kinds of automation rules. It's very powerful) we setup a rule to override the weight and adjust it to 200lbs on import.
This is more than the shipping companies allow, so it forces us to weight the packages.
Of course we have a scale connected to ship station to it's just the click of a button with the box on the scale, to get a 100% accurate weight.

If you are using barcodes (we are) you can use scan to print and the package weights itself...

FYI - You can find refurb Mettler Teledo scales on ebay for a fair price. I have 4 of them - all work well.

If that doesn't help your situation, perhaps some other users will benefit.

Thanks,
David

Hi David,

Thank you for your reply.

We have scales hooked up as a backup but I guess the main thing we were trying to do is use the ShipStation rules on import to apply the correct shipping so it's only one click to get a label and mark as shipped.

Fortunately our products are fairly standardized, as is our packaging and over the last 10+ years of using ECT we have been able to accurately enter all our weights so they are accurate to within a few grams.

Hopefully a fix can be found as it seems a shame not to be able to use it to it's full potential.
As you say it's powerful and has a lot of features especially when you dive into the automation rules.

Regards,
David

quote:

---

From what I can tell it's multiplying the base weight of 0.14Kg by 1000 to get the 140g but then just adding on the option weight of 0.08 to get 140.08 when it should be 222g.

---

Thanks for the detailed explanation here and I believe I've fixed this now. If you get a new copy of the updater and copy the ajaxservice.php script to your site it should sort it out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,

Thank you for looking at this.

I will download a new copy of the updater and do some testing.

1st class support as always

Regards,
David

Hi Vince,

I have done some testing and it looks like there may be a little bug on line 238 of ajaxservice.php as I was getting an error log appearing.

I think (but you would know better than me):
,0,50
needs moving to after ordLastName rather than ordName.

When I did this I had no more error logs appear.

I can send you details of the error if you need them.

Unfortunately when testing though it looks like it's now only importing the product base weight into ShipStation as I only get 140grams.

The product base weight is 0.14 and the dependent option weight diff is 0.082 making 0.222.

Regards,
David

Hi,

Just giving this a little bump as it looks like it might of get buried.

Regards,
David

My apologies for the delay David but both of these are fixed now and if you get a new copy of the updater and update the vsadmin/ajaxservice.php script that should sort them out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,

Many thanks. The error log has stopped

For some reason though I am still only getting the product weight being imported and it's ignoring the dependent option weight.

The weight in ECT admin is fine.
I also checked the cartoptions table and I have 0.082 in coWeightDiff which is being added onto the base weight of 0.14 just fine in ECT but the coWeightDiff is not being added onto and then multiplied by 1000 when imported into ShipStation.

Would it be possible to find a fix for this please?

Regards,
David

Hi David
I tried this here and it works, no problem at all. Can you make sure this is for a new order as it's not going to update an order that has already been imported.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,

That's very odd. It was a new order when I tested and then imported into ShipStation.

When using the earlier version it was importing the dependent option weight, just not x1000.

On the last two versions of ajaxservice.php it's just base weight.
I have double checked to make sure using the same product and option each time.

I also checked the last two versions of ajaxservice.php to make sure I have copied the lastest although when I did a comparison I noticed the coWeightDiff line that was updated is the same on the last two versions.

Is that correct or do I need to grab another copy?

Regards,
David