5 replies to this topic

[Rakesh Sharma]

Hi,
I have a live shop on designurt.com, I am using 3.0a5 version of Oscommerce. I am facing following problems:

1. In checkout.php page order total now showing correctly for example It showing like this:

Product                   1           Rs599.00
  Subtotal                            Rs599.00
  Flat Rate (Best Way):         Rs150.00
  Total:                       Rs150.00

It should show Total amount: Rs749.00 (Item price+shipping=total).

2. When I add color variant to product it doesn't work and I get following js error in a webpage (http://www.designurt.com/products.php?Beans) mentioned below:

Webpage error details
Message: 'document.getElementById(...)' is null or not an object
Line: 77
Char: 3
Code: 0
URI: http://www.designurt.com/templates/default/javascript/products/info.js

And it doesn't proceed to Add to cart page.

If any one can help me effort would be appreciated.

Thanks
Rakesh Sharma

[blackwater]

If you simply modified the stock osc3.0a5 without researching the issues then your store will not work correctly.

A good starting base to use is found here:

http://addons.oscommerce.com/info/7379/v,30

From experience with osc3.0a5, "order totals" appear bug free.

If you had not made changes to affect the operation then you might want to check your currency configuration.

Title: Rupees
Code: INR
Left Symbol: Rs
Right Symbol:
Decimal Places: 2
Currency Value: 1.00000000

Then check the shipping module that you have just a decimal for the flat rate, eg; 65.00


For variants, you might get some issues after you delete a product with variants and then create more products with variants. This is because the delete function is broken.

You will need to manually clear the relevant records from the database and fix the bug in the code.

Edited by blackwater, 03 September 2010 - 12:19 AM.

[Rakesh Sharma]

blackwater, on 03 September 2010 - 12:19 AM, said:

If you simply modified the stock osc3.0a5 without researching the issues then your store will not work correctly.

A good starting base to use is found here:

http://addons.oscommerce.com/info/7379/v,30

From experience with osc3.0a5, "order totals" appear bug free.

If you had not made changes to affect the operation then you might want to check your currency configuration.

Title: Rupees
Code: INR
Left Symbol: Rs
Right Symbol:
Decimal Places: 2
Currency Value: 1.00000000

Then check the shipping module that you have just a decimal for the flat rate, eg; 65.00


For variants, you might get some issues after you delete a product with variants and then create more products with variants. This is because the delete function is broken.

You will need to manually clear the relevant records from the database and fix the bug in the code.

Thanks for your reply. I have checked my currency configuration it is correct. But one more thing I have noticed in my DB is that my default currency has set as INR and transaction currency has set as USD does this any affect?

[Rakesh Sharma]

My above first issue related to order totaling has been fixed. Actually it was my mistake in some file. Now order total is working fine.

[blackwater]

In any case, if your product database has become corrupt because of the delete function then:

1. Fix delete product code.

/catalog/admin/includes/applications/categories/classes/categories.php
/catalog/admin/includes/applications/products/classes/products.php
/catalog/admin/includes/applications/products/products.php

you can find these updated files in the download link I posted earlier.

2. Backup Database
2. Install Smoothe Populate
3. Export Complete product .csv to temp directory
4. Delete all categories which in turn deletes all products
5. Manually clear out orphaned entries from the database in:

osc_categories
osc_categories_description
osc_manufactures
osc_manufacturers_info
osc_products
osc_products_description
osc_products_images
osc_products_to_categories
osc_products_variants
osc_products_attributes

6. Import Complete .csv from temp directory with SP

If problem persist, investigate other changes that were made to the code possibly compounding the problem.

[Rakesh Sharma]

blackwater, on 04 September 2010 - 02:33 PM, said:

In any case, if your product database has become corrupt because of the delete function then:

1. Fix delete product code.

/catalog/admin/includes/applications/categories/classes/categories.php
/catalog/admin/includes/applications/products/classes/products.php
/catalog/admin/includes/applications/products/products.php

you can find these updated files in the download link I posted earlier.

2. Backup Database
2. Install Smoothe Populate
3. Export Complete product .csv to temp directory
4. Delete all categories which in turn deletes all products
5. Manually clear out orphaned entries from the database in:

osc_categories
osc_categories_description
osc_manufactures
osc_manufacturers_info
osc_products
osc_products_description
osc_products_images
osc_products_to_categories
osc_products_variants
osc_products_attributes

6. Import Complete .csv from temp directory with SP

If problem persist, investigate other changes that were made to the code possibly compounding the problem.

Thanks for your reply. Can you look at this thread I have posted: http://forums.oscommerce.com/topic/363936-product-variant/page__p__1530840__hl__product%20variant%20in%2030a5__fromsearch__1&#entry1530840