Thanks!
Type: Posts; User: Brian1234
Hi,
I'm repairing our zen-cart store a bit after developers (and I use that term loosely) messed some things up on us. I have the secure pages 'lock' displaying properly in the browser again but...
I'm looking for some more help with this.
I looked into Virtual Products but that seemed like it's more for downloads, etc. I also see there is a Product Type with free shipping but that...
I suspect this has been asked and answered before but I'm not finding an exact case in Search. Tips here or a pointer to an appropriate thread would be appreciated. We have a store that's been...
Thanks again DrByte. :^)
I've reviewed the changes in the related tables and they seem apropos. Order history looks good in the admin and user UI's too, reflecting the changes.
OK, thanks! Would you take a look and see if this looks appropriate for zen-cart?
INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments)
VALUES...
Yes, I gathered that, but I was hoping for more info on 'how to'. Can you point me to any particularly good threads that discuss how to properly change orders_status and order_status_updates to...
augh! I did make a backup first though.
So back to the original question. How to properly change order status in bulk (or just properly delete all existing orders, we really don't need the...
In case it helps someone later, I believe I did this correctly with an SQL query in PHPMyAdmin:
UPDATE orders SET orders_status=3 WHERE orders_status=2
In that sample, all orders records with...
I figured out how to add the 5th order status, History, but am still wondering about a good way to do a bulk change to that status. Any tips appreciated!
Hi,
Is there an easy way to set all orders with 'Processing' status to 'Delivered'? I have a hundred-some and one-by-one would be a pain. I might be able to handle some SQL code if that's the way....
AHA! Got it!
The old DB had a table prefix I hadn't noticed. Once I edited the config files for that, all is well.
Thanks for the replies Muzz.
ZC is not having a problem connecting to the DB. It appears to be having trouble finding a table or table data once connected.
Oh, and since the current release of ZC was in 2007, I'm 99 &...
It's a clean / new ZC install, the only files I uploaded besides the stock ZC ones are my custom template.
Since it is operational with the post-install data in the DB I believe the names, PWs...
Hi, I'm having trouble rebuilding a Zen-Cart store. The previous and current store both are the current version.
I backed up my original DB, created a new DB and installed ZC into the new DB fine....
I too am concerned that you went from an 'int' to a 'varchar', to store integer data. Can you expound on why that choice? Have you set in stone what type of field will be in v1.4? I'm concerned what...
I’ve been adding a new set of products to our store, but I’m having serious issues while implementing the attributes. While creating attribute lists after about 3-5 requests from the server, the...
I've gotten even closer but have not been able to figure this out.
First of all, I have added this at line 861 of admin/orders.php:
$contents[] = array('text' => "I WANT cc_type TO GO HERE");...
I tried editing orders.php at line 412 with the added fields, but that's not the right place... that shows when I click on the 'e' for edit and that screen already has the cc_type and cc_number info....
Aha, I have made some progress. I have it going for admin/invoice.php, with this code at line 150:
<td class="main"><?php echo $order->info['payment_method'] . " (" . $order->info['cc_type'] . " " ....
How can I make the credit card type (Visa, MC, etc) display in the admin section:
1) On the Orders page: in the order summary in the right column
2) On the Order Invoice itself
Currently it only...
I'd thought it was at the Store Home page but just checked and it's not https there... I must have been on a secure page. Sorry!
OK, I'll leave that alone. I guess that means I should link to it as http. I'm still curious why the CSS is https though.
- Bri
Looking at the links on my store's home page, most of the links are http not https.
The only two links with https are the stylesheet and the link to Log In. I understand the https is really only...
Found it in Configuration > My Store ... must've just missed it the first time.
Where is the cURL proxy setting I've seen mentioned?
AH GEEZ!! That's it. I thought I had turned something on to see what it would do, and was chasing a ghost.
Good news: I have my store virtually done! The ISP is still chasing the slowness...
Aha - I forgot the "td" when I tried it.
And THANKS for the other tweaks, the left-justification, top-align and bottom border all look great!!
OK that worked, thanks.
Still trying to find the extra email setting. In Configuration > Email Options everything is off except for "Send Low Stock Emails". I've also looked through Configuration...
I turned on something and can't find it again... I am receiving an extra email upon order confirmation from the store.
The one I'm use to seeing has this subject:
[NEW ORDER] Order...
How do I add a little space between the items in a productListing? Specifically, when I go to a category with multiple products, the image for each product touches the next image (vertically). I...
Oh, THANKS! I never saw all that in the Product Types > General > Edit Layout section!
The other thing I was asking for is to get rid of the "No Picture Available" graphic and "larger image" link...
Thanks ... I must have breezed right by them.
Thanks! The CSS recommendation was spot-on... I had been thinking about space on top of the footer but that solution is just right.
Thanks for the other pointer... I saw the separator stuff in...
Thanks! I had already shut off the ones in Configuration / Stock but didn't see all those under the Config / Index.
Still, I have the "New Products ..." link and separator line ine the main...
On an individual product's page:
I have turned off the sideboxes for Reviews and Tell A Friend but on my product page it still shows buttons for Write A Review and Tell A Friend. Can I shut these...
I've removed the New Products sidebox, but still have the "New Products for February" box showing in the center of the home page, and "New Products ..." in the categories box as well. Is there an...
Oh, ok, it's doing it again already (now 8:50pm):
Parse Time: 25.991 - Number of Queries: 78 - Query Time: 25.200709677689
Does this mean the SQL back-end took 25.200 seconds and the other .791...
I'm still looking for help on this point:
Thanks! At the moment I'm seeing <1 sec parse time most of the time, <2 all the time. I'll see what it does tomorrow afternoon.
My new install runs quite slow at times, and I'm suspecting something at the ISP is causing it... like PHP or SQL server overload. Now at 8pm I can change pages in the store real fast, like 2-3...
Thanks - this thread helped me out too.
Now I'm wondering where to find the email that is sent when a person makes an order... it seems like it would be one of the checkout_*.php files but I'm not...
I figured out how to take the link out of the sidebox in the admin interface, as well as out of the Customer sign-in/Account page... anything else I need to take out related to newsletters?
I'm doing pretty good customizing my new install but have a few misc questions:
1) For pages where the total height of the sideboxes is taller than the content, the bottom sidebox touches the...
I have a new install that's giving me "500 Internal Server Error" messages (nothing in the PHP logs) and I'd like to start by having someone check some of my path settings. I don't have a public_html...
DrByte,
Thanks SO much for trying. I think I have to stop kicking a dead horse here.
I don't think that was the right line but I made the change to all the queries in that file and still get...
Last post moved to:
http://www.zen-cart.com/forum/showthread.php?p=512593
I tacked this onto an older thread but didn't receive a reply.... trying here...
I guess the first thing that I see in the errors is that p.products_id is not found, but the field exists and seems...
Due to continuing problems getting the new version installed from scratch (mainly a mostly unresponsive ISP) and the need to get something back up and running, I am hoping someone here can help with...
Sorry, I'm still confused about what I should do. Posts like
https://www.zen-cart.com/tutorials/index.php?article=142
say to copy over the stylesheet.css. I assumed that was so I would edit my...