Download PDF questions

Hi Nicolas,
Followed your suggestions as best as I could.
Receipt text isn't working.
Shipping cost issue is still a problem.

Redirect to correct page is working!

Please advise.

thanks,
Jeff

Sure thing.

EBooks = download, no weight
Clickers = $6.00 cost $2.50 shipping

If anyone orders anything besides clickers, the cost starts at $3.99 for orders of $6.01 and higher.

EBooks should be zero shipping. The $2.50 charge works if I just order clickers, but if I add an EBook the shipping jumps to $3.99 and it should stay $2.50

Thanks.

Okay, so if I sell different products with different weights. I need to figure out how much they would add up to for each price?

For instance, the M/L harness weighs 5.8 oz and the large harness weight 6.0 oz and they both cost 20.95.

Since two M/L harnesses would put the customer over the 39.99 price point and they weigh 11.6 oz.

So, 11.7 oz would be the next shipping weight?

Is that the right line of thinking?

It seems like I would have to do a lot of calculations and things could change if I start carrying different products with different weights.

Am I missing something?

Also . . . I can't get to the characteristics page where it shows

small red
small blue
small black

medium red
etc.

When I select "manage variants" I get an error that says "A product with the same code already exists
Error Saving"

I will need to go back to that page, I think, to adjust inventory before I go live.

Here is the error:


JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=UPDATE `jos_hikashop_product` SET `product_name`='SENSE-ible Harness',`product_url`='',`product_meta_description`='',`product_keywords`='',`product_code`='SENSE_ible_Harness',`product_tax_id`='',`product_sale_start`='',`product_sale_end`='',`product_contact`='0',`product_quantity`='-1',`product_min_per_order`='0',`product_max_per_order`='0',`product_weight`='0.000',`product_weight_unit`='lb',`product_length`='0.000',`product_width`='0.000',`product_dimension_unit`='in',`product_height`='0.000',`product_published`='1',`product_access`='all',`product_group_after_purchase`='',`product_type`='main',`product_description`='

This is simply the best training harness you can buy. The unique design places the connector on the front and allows you to simply guide your dog in the right direction by using gentle leverage. Useful for dogs that pull as well as dogs that exhibit on leash aggression. Jeff has been successfully using this product for years.

\r\n


\r\n
One of the really nice aspects of this product is that dogs usually acclimate to it instantly. Put it on and go! You should see a noticeable improvement in your capabilities of keeping your dog under control.

\r\n


\r\n
As with any training tool, training is an important component to successfully using it. Use the positive reinforcement strategies found at Watch and Train in conjunction with this amazing product and you will be really happy with the results.

',`product_modified`='1302275018' WHERE product_id='18'
Call stack
# Function Location
1 JAdministrator->dispatch() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/index.php:67
2 JComponentHelper->renderComponent() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/includes/application.php:136
3 require_once() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/application/component/helper.php:162
4 JController->execute() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/admin.hikashop.php:47
5 ProductController->managevariant() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/application/component/controller.php:236
6 hikashopController->store() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/controllers/product.php:51
7 hikashopProductClass->saveForm() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/helpers/helper.php:694
8 hikashopProductClass->save() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/classes/product.php:127
9 hikashopClass->save() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/classes/product.php:303
10 JDatabaseMySQL->updateObject() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/helpers/helper.php:778
11 JDatabaseMySQL->query() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/database/database/mysql.php:583
12 JError->raiseError() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/database/database/mysql.php:231
13 JError->raise() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/error/error.php:171
14 JException->__construct() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/error/error.php:136

I did that and now I get this error.


500 - An error has occurred.

JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=UPDATE `jos_hikashop_product` SET `product_name`='SENSE-ible Harness',`product_url`='',`product_meta_description`='',`product_keywords`='',`product_code`='SENSE_ible_Harness',`product_tax_id`='',`product_sale_start`='',`product_sale_end`='',`product_contact`='0',`product_quantity`='-1',`product_min_per_order`='0',`product_max_per_order`='0',`product_weight`='0.000',`product_weight_unit`='lb',`product_length`='0.000',`product_width`='0.000',`product_dimension_unit`='in',`product_height`='0.000',`product_published`='1',`product_access`='all',`product_group_after_purchase`='',`product_type`='main',`product_description`='

This is simply the best training harness you can buy. The unique design places the connector on the front and allows you to simply guide your dog in the right direction by using gentle leverage. Useful for dogs that pull as well as dogs that exhibit on leash aggression. Jeff has been successfully using this product for years.

\r\n


\r\n
One of the really nice aspects of this product is that dogs usually acclimate to it instantly. Put it on and go! You should see a noticeable improvement in your capabilities of keeping your dog under control.

\r\n


\r\n
As with any training tool, training is an important component to successfully using it. Use the positive reinforcement strategies found at Watch and Train in conjunction with this amazing product and you will be really happy with the results.

',`product_modified`='1302293116' WHERE product_id='18'
Call stack
# Function Location
1 JAdministrator->dispatch() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/index.php:67
2 JComponentHelper->renderComponent() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/includes/application.php:136
3 require_once() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/application/component/helper.php:162
4 JController->execute() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/admin.hikashop.php:47
5 ProductController->managevariant() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/application/component/controller.php:236
6 hikashopController->store() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/controllers/product.php:51
7 hikashopProductClass->saveForm() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/helpers/helper.php:694
8 hikashopProductClass->save() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/classes/product.php:127
9 hikashopClass->save() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/classes/product.php:303
10 JDatabaseMySQL->updateObject() /hermes/web10/b2752/moo.watchandtrain/YourShop/administrator/components/com_hikashop/helpers/helper.php:778
11 JDatabaseMySQL->query() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/database/database/mysql.php:583
12 JError->raiseError() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/database/database/mysql.php:231
13 JError->raise() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/error/error.php:171
14 JException->__construct() /hermes/web10/b2752/moo.watchandtrain/YourShop/libraries/joomla/error/error.php:136

Thanks the database fixed work.

I am still having shipping pricing issues.

I have a new error: "the cart items combined weight is too big for all the possible shipping methods."

This error happened in conjunction with the shopping cart image that you can see below. The cart wan't very full, as you can see, there just must be an error in how it can choose a shipping method?

Enclosed are 3 pics. One of the shipping options, prices and weights.

The other is the shopping cart. The 3rd is the error message.

The EBooks are absolutely zero weight.

I ALSO HAVE ANOTHER QUESTION:
Is there any way that the EBooks DON'T count towards the shipping total to increase the price, but DO decrease the price to ZERO when my customer orders more than 99.99 worth of any products?

I am not sure if this is possible.

The EBooks are not getting charged for shipping when it is just the EBook in the cart, (good) but they do add to the shipping cost when they are in the cart with another physical product (bad), and the Ebook "pushes" the price to the next shipping level. (bad).

Thanks.

Thanks. I am assuming the error message is because of strange numbers that dont' work together.

I will change it to the volume method and see if that works. That makes sense.

One Question:
Do I need to worry about the weight parameters at all when I am using volume, or is it one or the other?

Thanks for your help.

Thanks. One more question. If I don't care about weight and only price. Can I just set the volume and delete the weight parameters? Or do I need both?

That would be a LOT easier.

thanks.