Discussion Forum: Thread 329184

 Author: xdennisma View Messages Posted By xdennisma
 Posted: Oct 29, 2022 23:57
 Subject: How to select all items in inventory >2cm?
 Viewed: 85 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

xdennisma (1283)

Location:  Canada, British Columbia
Member Since Contact Type Status
Oct 3, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: EpicUltraBricks
This might not be possible, but is there a way to sort/filter/select all parts
currently in my inventory with a BrickLink catalog packing height equal to or
greater than 2cm?

Since 2cm is the Canada Post height restriction, I would like to add a note to
all such parts so that customers are aware that adding those items to an order
will automatically trigger the much-more-expensive parcel rate.

I really do not want to have to go through all items individually to isolate
just those parts!
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Oct 30, 2022 00:07
 Subject: Re: How to select all items in inventory >2cm?
 Viewed: 38 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1182)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Packing Dimensions, xdennisma writes:
  This might not be possible, but is there a way to sort/filter/select all parts
currently in my inventory with a BrickLink catalog packing height equal to or
greater than 2cm?

Since 2cm is the Canada Post height restriction, I would like to add a note to
all such parts so that customers are aware that adding those items to an order
will automatically trigger the much-more-expensive parcel rate.

I really do not want to have to go through all items individually to isolate
just those parts!

You can change your shipping options in IC so that only items up to 2cm have
IC available. Then go to the inventory page and filter by IC unavailable.
 Author: xdennisma View Messages Posted By xdennisma
 Posted: Oct 30, 2022 00:22
 Subject: Re: How to select all items in inventory >2cm?
 Viewed: 42 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

xdennisma (1283)

Location:  Canada, British Columbia
Member Since Contact Type Status
Oct 3, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: EpicUltraBricks
Thanks for the quick reply! However, I thought I already had this restriction
enabled, yet selecting this field on the Inventory screen does not bring up any
parts (yes, I do have several parts in inventory that exceed 2cm.)

To clarify, for my Store Settings, under the Shipping tab in the "Restrictions
and Adjustments" section for my main shipping option, I have a Max Dimension
of "2cm" showing for the middle "(h)" field.

Is there any other way of adding in the height restriction to this shipping option,
to align with what you proposed?
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Oct 30, 2022 00:45
 Subject: Re: How to select all items in inventory >2cm?
 Viewed: 44 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (875)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Wild Chicken
In Packing Dimensions, xdennisma writes:
  Thanks for the quick reply! However, I thought I already had this restriction
enabled, yet selecting this field on the Inventory screen does not bring up any
parts (yes, I do have several parts in inventory that exceed 2cm.)

To clarify, for my Store Settings, under the Shipping tab in the "Restrictions
and Adjustments" section for my main shipping option, I have a Max Dimension
of "2cm" showing for the middle "(h)" field.

Is there any other way of adding in the height restriction to this shipping option,
to align with what you proposed?

I believe that filtering for instant checkout unavailable returns only parts
where instant checkout is unavailable in general; i.e., the part is missing weight
and/or dimensions in the catalog. If you override the catalog dimensions with
your own, then those parts will qualify for instant checkout even if they don't
meet your shipping method restrictions.

Are you trying to filter out all parts that have any dimension over 2 cm, or
only parts where all three dimensions exceed 2 cm? Or only parts where the height
exceeds 2 cm? For example, would a 6 x 16 plate ship as lettermail or parcel?

Regardless, I'll leave this one to the Canadian/British sellers since in
my experience the way the instant checkout algorithm calculates volume and dimensions
often returns unexpected results.
 Author: xdennisma View Messages Posted By xdennisma
 Posted: Oct 30, 2022 01:06
 Subject: Re: How to select all items in inventory >2cm?
 Viewed: 36 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

xdennisma (1283)

Location:  Canada, British Columbia
Member Since Contact Type Status
Oct 3, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: EpicUltraBricks
Thanks for the reply! Based on the fact that this filter option for "Instant
Checkout Unavailable" does not return any results for my inventory, I am inclined
to believe that your statement about which results it returns is correct.

To clarify, for now I am only looking for those items with a height of 2cm, as
the restrictions for length and width are much larger (27cm+). I can work on
isolating those parts that are too long or wide later, as there are fewer of
them.

I really hope there is a way of applying this filter!
 Author: jbroman View Messages Posted By jbroman
 Posted: Oct 30, 2022 06:32
 Subject: Re: How to select all items in inventory >2cm?
 Viewed: 59 times
 Topic: Packing Dimensions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

jbroman (983)

Location:  Canada, British Columbia
Member Since Contact Type Status
Oct 16, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Big Boy's Bricks
In Packing Dimensions, xdennisma writes:
  Thanks for the quick reply! However, I thought I already had this restriction
enabled, yet selecting this field on the Inventory screen does not bring up any
parts (yes, I do have several parts in inventory that exceed 2cm.)

Filtering by IC unavailable will only show parts:
-that are set to a manual package type, or
-if the weight is missing (if set to weight bound), or
-if any of the dimensions are missing (if set to volume bound).

  To clarify, for my Store Settings, under the Shipping tab in the "Restrictions
and Adjustments" section for my main shipping option, I have a Max Dimension
of "2cm" showing for the middle "(h)" field.

This dimension is used to calculate the max volume of a package.

To complicate your search, looking at just the height of a part to see if it's
more than 2 cm will not give you what you want. You need to exclude any part
where any of the three dimensions is less than 2 cm.

For example, a 1x6x5 panel will show in your search as it is more than 2 cm in
height. but the system realizes the panel can lie down. In other words, it looks
at the smallest of the dimension fields to determine "volume" height.

To complicate things, the dimensions listed in the inventory don't follow
the package restriction dimensions of w x h x d.

Parts follow d x w x h:
DimX = Depth (shortest of the two horizontal dimensions)
DimY = Width (longest of the two horizontal dimensions)
DimZ = Height (vertical dimension)

Minifigures and sets use w x h x d (as if it is standing up)
DimX = Width
DimY = Height
DimZ = Depth

https://www.bricklink.com/help.asp?helpID=2510
  
Is there any other way of adding in the height restriction to this shipping option,
to align with what you proposed?

I have the following set for package restrictions for my lettermail shipping
method:
37 cm(w) x 1.85 cm(h) x 26 cm(d)
I use slightly smaller dimensions than allowed by Canada Post to account for
packaging.

I only add a remark if the part is close to the max thickness allowed with lettermail.

----------------------------------
With regards to Packing Type setting: Weight Bound should be used for parts that
are approximately 2 x 2 x 2 cm and smaller.

From Admin Russell: https://www.bricklink.com/message.asp?ID=1342842
One aspect of the system that is not widely known or understood is the effect
of packing dimensions on weight bound items - these are small parts. Even though
an item is weight bound and will not cause a direct issue with size, when the
volume calculation is performed at the end of the process, packing dimensions
are used to calculate the total liquid dimension (volume). Small parts containing
a lot of empty space may trigger a volume issue even though the weight was within
the limits.