Forums / General Questions / Shipping and Tax cost not showing in Admin

Shipping and Tax cost not showing in Admin

Views: 1,170

Results 1 to 16 of 16
23 Mar 2015, 1:56 PM
#1
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Shipping and Tax cost not showing in Admin

I am working with Zencart 154 and the shipping and tax costs are not showing in Admin. once the order is submitted. (this is a test site)

The costs do show up when placing the order and also when I get a copy of the emailed order.

Mods that I installed are;
how_did_you_hear_about_us_v150
reviews_updated
ceon_manual_card_4.0.1_for_zc
IntegratedCOWOA_2.4
ty_package_tracker_v_3-1-3

I am sure I installed something incorrectly in a file but I don't know what file to start looking in.
Any Ideas?

Thanks in advance for any help.

23 Mar 2015, 2:06 PM
#2
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: Shipping and Tax cost not showing in Admin

Start with the file that loads the page you are looking at in admin, look in the address bar:

http://your_domain_name.com/YOUR_ADMIN/orders.php

Although a few files 'build' the display, the first one to look at would be admin/orders.php

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

23 Mar 2015, 2:48 PM
#3
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

Thanks twitchtoo
I checked that file and the only thing that I added was from the mod, how_did_you_hear_about_us_v150

around line 458 I added

<?php //rmh referral start $cust_id_query = "select customers_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"; $cust_result = $db->Execute($cust_id_query); $cID = $cust_result->fields['customers_id']; $source_query = "select customers_info_source_id from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$cID . "'"; $source = $db->Execute($source_query); $entry_referral = zen_get_sources_name($source->fields['customers_info_source_id'], $cust_result->fields['customers_id']); echo $entry_referral; //rmh referral end ?> </td> </tr>

Could this have anything to do with the problem? I am not very well versed in coding.

23 Mar 2015, 4:21 PM
#4
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

I deleted the item from the orders file and found that it was not the problem.

Any other ideas?

23 Mar 2015, 4:30 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Tax cost not showing in Admin

If you go to phpMyAdmin, and search the orders_total table for the orders_id that isn't showing the shipping and tax costs, on the records that come up, what shows in the field for class?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Mar 2015, 4:43 PM
#6
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

Ajeh:

If you go to phpMyAdmin, and search the orders_total table for the orders_id that isn't showing the shipping and tax costs, on the records that come up, what shows in the field for class?

Not quit sure I follow you but under the class column in the tax row I have:
title text value class
MN TAX 6.875%: $0.72 0.7219 ot_tax

Is that what you mean?

23 Mar 2015, 5:23 PM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Tax cost not showing in Admin

Are you saying you just have the 1 record on the table orders_total for that orders_id?

If so, go to your Zen Cart Admin and go to Modules ... Order Total ... and what Order Total modules are installed and what are their Sort Orders?

Is Shipping ot_shipping installed?

Is Tax ot_tax installed?

Are the icons on the ones that are installed green?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Mar 2015, 5:40 PM
#8
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

Ajeh:

Are you saying you just have the 1 record on the table orders_total for that orders_id?

If so, go to your Zen Cart Admin and go to Modules ... Order Total ... and what Order Total modules are installed and what are their Sort Orders?

Is Shipping ot_shipping installed?

Is Tax ot_tax installed?

Are the icons on the ones that are installed green?

I don't know what you mean by your first question. This is a test site if that matters.

All these are installed and are green
Modules, Sort, Order, Action

Discount Coupon ot_coupon 830 Info
Group Discount ot_group_pricing 290 Info
Gift Certificates ot_gv 840 Info
Low Order Fee ot_loworderfee 400 Info
Shipping ot_shipping 200 Info
Sub-Total ot_subtotal 100 Info
Tax ot_tax 300
Total ot_total 999 Info

23 Mar 2015, 5:55 PM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Tax cost not showing in Admin

If you login with a test customer account to your store and place an order, are these still missing?

If you look in your /logs directory on the server, do you see an recent debug logs?

If so, what do the recent ones contain? (NOTE: be sure to refresh the /logs directory in your FTP program to ensure it is current)

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Mar 2015, 6:12 PM
#10
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

I just did another test order.
Everything in the process of ordering on the test site look great with the costs. (shipping, payment, order review and order complete pages)

There is one debug log
[23-Mar-2015 18:02:04 UTC] ERROR: Failed sending email to: "" <> with subject: "[NEW ORDER] Order Confirmation No: 1151" (failed validation)

What does it mean?

As stated in the start of this post, when the confirmation emails come back to me, all the costs are correct.

It's just in the Admin of the site that has no costs;
Sub-Total: $0.00
Flat Rate (Best Way): $0.00
MN TAX 6.875%: $0.00
Total: $0.00

23 Mar 2015, 6:15 PM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Tax cost not showing in Admin

Is this a clean install of Zen Cart v1.5.4 or an upgrade?

Do you have something like Beyond compare from scootersoftware.com that you can use to check that all of the files on the server are loaded correctly?

Is Order 1151, the one you just made?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Mar 2015, 6:25 PM
#12
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

This was a new install but I did import a database from our live site (139h)

I don't have anything from scottersoftware.com or anyone else that can check on the files to the server.

Yes, this order is 1151

23 Mar 2015, 6:33 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Shipping and Tax cost not showing in Admin

I really like Beyond compare from scootersoftware.com as you can compare a clean Zen Cart v1.5.4 to your current copy on your computer as well as your server to see where a file might be missing, out of date or changed to help locate problems ...

I am assuming when you did the import of your v1.3.9 database into your v1.5.4 database that you ran the Upgrade on the v1.5.4 database, correct?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Mar 2015, 6:39 PM
#14
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: Shipping and Tax cost not showing in Admin

No I did not do the database upgrade. I found it easier to do it the other way. I can remember having problems trying to do the upgrade so I just did the import the way I always done it in the past. (I do remember wishing there was a video on the whole process of a upgrade.)

If you feel that I am missing files. Can you tell me roughly what folders to check?

23 Mar 2015, 9:19 PM
#15
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: Shipping and Tax cost not showing in Admin

If the db has not been upgraded properly the new install may be looking for a table, or column that doesn't exist on the admin side. You'll need to run the zc_install db upgrade program on your current db... AFTER you've backed it all up of course. Then at least you will get an 'everything updated okay' or an error report... and **then **we can assume that the db structure is correct.

You could also check your PM for info on getting help to resolve this issue... :)

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

24 Mar 2015, 2:53 AM
#16
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: Shipping and Tax cost not showing in Admin

Okay, here's what happened:

**admin/classes/**orders.php

had been wrongly overwritten by

**includes/classes/**orders.php

which was merged for COWOA.

After a peek at the COWOA module which currently only supports zc v1.51, along with a slightly awkward set of instructions/fileset... it was clear what had happened.

So I replaced admin/classes/orders.php with a clean copy from the original zen cart v1.54.

Thanks to Maynards for access, and swift feedback to get this fixed!

P.S.
Other problems encountered that were **unrelated **to this problem but worth mentioning... the 300MB database. Email Archiving was turned on, which stored every email from the cart's inception... over 40,000 emails. After emptying the table... 7.1MB of database is now manageable :)

For anyone reading this that has performed a zc version upgrade... Now would be a good time to check your db for excessive archiving ;)

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian