Implementing a split-box cost

[lyingit]

I'm looking for an add-on that will allow me to implement a split box cost, if there is a way to use easy populate with it, bonus.

The site I'm working on has a supplier who has a split-box charge added on if you order less than the total box size, but I want to sell individual items, and not eat the split box charge.

so if a box is 50 items, and the customer wants 1-49, they get the charge, but also if they want 51-99 and so on.

they'd only not get the charge if they ordered a complete box (in theory, the charge would be wiped if they ordered enough, but that could be dealt with internally).

so any way to do this?

[gjh42]

You might have attributes for whole cases (qty dropdown) and for 1-49 individual items (qty dropdown). The individual attribute could have a one-time charge (see Catalog > Attributes Controller). You would limit the product to one (no qty box on the add to cart) and handle quantities in the attributes.

[lyingit]

Thanks for your reply, I'm having a look at this today, should work, although now you have me wondering if there is a fast way to assign attributes, I'll have to look at that now too.

(really new to all of this, just trying to help a guy out)

[lyingit]

Ok, there has to be a fast way to assign these right?

as I have box quantities up to 100, I've made two attributes, Quantity (Box) and Quantity (Piece), I have it so that a customer can order up to 5 boxes, and then up to 99 pieces. But setting a price point for each attribute takes a fair bit of time.

Can I use a template of sorts with Easy Populate to both set attributes, as well as their price points?

for reference I have over 2500 items to set this pricing on, and I could quickly do this with Excel and then turn it into a tab delimited file for upload as opposed to setting it for each individual item (up to 105 times for each item, that could take forever).

I have to imagine there is an easy way to do this no?

[gjh42]

You can copy the attributes wholesale from one product to a whole category, if they should have the same quantity setup. Look for the "copy to category" button at the top of the Attribute Controller.

Setting different prices on attribute values per product does not have an automated method. You could import that data into the db (though I understand ep doesn't handle attributes) if you understand databases and the structure of the ZC db. An expert could tell you how in more detail.

[lyingit]

yeah using the attributes sheet I was able to do two products pretty much automatically, now I'm working with the site admin to try to get him to parse the attributes/option values straight into the sql database (to save me manually entering up to 500 options to the quantity (pieces) field)

So thanks for your help, you've got me on the right track, just need to get over the hump.

[lyingit]

n/m, setting the option to not use 0 as a base price helped today's issue