Does bazaar rev 748 = beta 2?

Is adding a section to add tracking numbers to completed orders in the todo list anywhere?

I've got a module I wrote that will display tracking information obtained in real-time from USPS, FedEx, or UPS. I plan on posting this as a contribution soon.

Can't you just edit the Free Product and set the Flatrate per-product rate to $0? The store default applies to all products except when you have overridden it like this in the product edit menu.

Maybe I don't understand what you're asking?

Thanks for the replies TR and Torgos. I actually never noticed that the default flat rate was...only a default flat rate, and that it could be edited per product.

The flat rate example was just a simple example, though, to demonstrate my inability to hook into the shipping quotes and change the items that it was basing the quotes on, but I'd also need this to work with any of the other shipping modules enabled. I don't know how all of the existing shipping quote modules work, but I don't think just setting 0 weight and dimensions would do the trick. I don't think I'll be able to do a (total shipping quote) - (free products shipping quote) type of thing either.

Torgos, on Ryan's suggestion I started this out using the Product Feature API which would allow you to add "Free Product" as a feature and then dictate the cart behavior based on that. It works nicely, but I'm stuck at this shipping quote snag now.

My tentative plan, which I've not gotten very far through, was this:

1. Add a product feature "Free Product"
1a. Add conditions for this to be a free product (another product is in cart, order total is over a certain amount, B1G1)
2. In the cart, display product as normal but if conditions are met, set price to $0
3. In checkout, if only free products are in the cart, streamline the checkout
4. In checkout, if priced and free products exist, free products will have a price of $0 and won't affect shipping or taxes, but checkout will proceed as normal otherwise.

I think I can do everything except #4. I'll have to take a look at how discount and gift certificate mods do $0.00 total order processing too and probably tie some of that in with #3.

I have just upgraded from ubercart alpha 8 to the betas.

After I run database update, I got a few errors.

If I upgrade directly from alpha 8 to beta 2, I got 3 item FAILED.
(attached as Drupal database update.pdf)

uc_flatrate module
Update #2
ALTER TABLE {uc_flatrate_products} CHANGE rate rate
decimal(10,2) NOT NULL default 0.00
ALTER TABLE {uc_flatrate_products} ADD COLUMN mid
mediumint(9) unsigned NOT NULL default 0 AFTER nid
CREATE TABLE {uc_flatrate_methods} ( `mid` mediumint(9)
unsigned NOT NULL default 0, `title` varchar(255) NOT NULL
default '', `label` varchar(255) NOT NULL default '', `base_rate`
decimal(10,2) NOT NULL default 0.00, `product_rate` decimal(10,2)
NOT NULL default 0.00, PRIMARY KEY (`mid`) ) /*!40100
DEFAULT CHARACTER SET UTF8 */ ;
Failed: INSERT INTO {uc_flatrate_methods} (mid, title, label,
base_rate, product_rate) VALUES (1, 'Flat rate per product', 'Shipping
rate', 0, )
UPDATE {uc_flatrate_products} SET mid = 1
Failed: UPDATE {workflow_ng_cfgs} SET name = '', data = 'N;'
WHERE name = 'uc_flatrate_get_quote'
INSERT INTO {uc_flatrate_methods} (mid, title, label, base_rate)
VALUES (2, 'Flat rate per order', 'Shipping rate', 5)
Failed: UPDATE {workflow_ng_cfgs} SET name = '', data = 'N;'
WHERE name = 'uc_flatrate_get_quote_by_order'

If I revert back to original database and upgrade to beta 1, I have one item FAILED. (no failure in uc_flatrate update #3 if I continue to upgrade to Beta 2.)
(attached as beta 1 update.pdf)

uc_flatrate module
Update #2
ALTER TABLE {uc_flatrate_products} CHANGE rate rate
decimal(10,2) NOT NULL default 0.00
ALTER TABLE {uc_flatrate_products} ADD COLUMN mid
mediumint(9) unsigned NOT NULL default 0 AFTER nid
CREATE TABLE {uc_flatrate_methods} ( `mid` mediumint(9)
unsigned NOT NULL default 0, `title` varchar(255) NOT NULL
default '', `label` varchar(255) NOT NULL default '', `base_rate`
decimal(10,2) NOT NULL default 0.00, `product_rate` decimal(10,2)
NOT NULL default 0.00, PRIMARY KEY (`mid`) ) /*!40100
DEFAULT CHARACTER SET UTF8 */ ;
Failed: INSERT INTO {uc_flatrate_methods} (mid, title, label,
base_rate, product_rate) VALUES (1, 'Flat rate per product', 'Shipping
rate', 0, )
UPDATE {uc_flatrate_products} SET mid = 1
INSERT INTO {uc_flatrate_methods} (mid, title, label, base_rate)
VALUES (2, 'Flat rate per order', 'Shipping rate', 5)

Anyone would like to tell me whether I should do something about it? or I can continue to use beta 2 ubercart as if it is running perfectly?

(I am going to test the beta 2 now and would post more if found more errors...)

Thanks
Eric

Generally, anytime you see "unknown field" in an SQL error, it means that table doesn't exist, or a new field that was supposed to get created, wasn't, and that's a fault of the Update or Install function in the .install file.

The reason your workaround "works" is because both the uc_file_products Contrib, and the core uc_file module, both use a table called uc_file_products. This was mentioned by Shawn when the core module was first introduced. It seems like you need to not just disable modules (such as the File Products contrib) but uninstall them altogether. Uncheck them from your admin/build/modules menu, and then click the Uninstall tab, and click Uninstall. You might even consider deleting the files off your server, in case they are still getting called for some wonky reason.

If that doesn't work, get into phpMyAdmin and remove the uc_file_products table manually, and reinstall the core module.

Hey Ryan, Lyle, Shawn, and Andy (the Uberdudes and Uberadmins),

I'd be interested to get your take on cYu's concept for the "Free Product" module as described in the thread above (and quoted below). I think this type of module is important... certainly free products are major part of marketing efforts on many of my own sites.

More specifically, does cYu's suggestion of hook_quote_order() and hook_tax_order() seem like a good approach?

Thanks,
Ben

We've just been asked about dependent attributes and would like to get an outline together of what is required to code this module. If anyone knows conceptually how this could be achieved please let me know and I'll try and create the module.

Hi Ryan,
I have got an alpha8 production site, with these modules: inventory/simple stock (with options and adjustments) + Terms. Using flatrate shipment is enough for now.

It roughly run correctly (no stock alert to client, shipment fine...) but we have to modify the stock everytime a product is sold !!!

Beta2 looks great: I migrated on a test server. Everything is cool (reports, stock management...) except Ajax behavior was lost in the migration!

What could I say?... HELP!

Any idea?

Alexandre

Yep!

Site master : http://monsieur-gimblette.net
Site test : http://v2.monsieur-gimblette.net (no paypal: safer...)

[we go mad because we start to have good buzz]

Cool, it a webserver trouble!
OK: what is the pb exactly? A chmod issue?

Was a stupid chmod issues

OK: everything looks good... except stock is not verified
Did I missed an option to toggle?

Thanks for your clues

ADD:
The rest of my interrogation go here: http://www.ubercart.org/forum/general_discussion/2513/uc_stock
I thought uc_tock was taking care of both...
Thank you for your time Ryan

Alexandre

hallo,
i've a little problem on ubercart.it.
i've upgraded to beta3 and when i delete a node i see this message:

"user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN uc_product_adjustments AS pa ON sl.model = pa.model W' at line 2 query: DELETE FROM uc_stocklevels AS sl LEFT JOIN uc_product_adjustments AS pa ON sl.model = pa.model WHERE pa.nid = 43 in /home/mhd-01/www.ubercart.it/htdocs/includes/database.mysql.inc on line 172."

I have had similar problems and would tend to agree with Ryan. In my testing, the error message does not seem to interfere with anything else. The site keeps on going. Otherwise the module works well with beta4.

thanks!