Search:

you could always try to re-format the cells in excel (right click, format cells, then under the "number" tab, select number or currency). might work, but I feel like these are hoops you shouldn't...

not sure.. when i export as "csv for excel", i have to go through the text-to-columns steps you referenced. however, when i export as plain old csv, it opens up fine in excel, already split into...

you might not have seen the edited part of my post, seems to work when exporting as csv (as opposed to csv for excel). not sure what exactly the difference is, probably adds some goofy microsoft...

doh! I copied your original code, which had the incorrect quotes around the orders_id field, try this:


SELECT `orders_id`,`customers_name`,`order_total`,`payment_method`, `date_purchased` FROM...

try this:


SELECT 'orders_id',`customers_name`,`order_total`,`payment_method`, `date_purchased` FROM orders WHERE date_purchased BETWEEN "2013-03-01" AND "2013-03-30"

ps - looks like you just...

Glad to hear! Don't hesitate to ask if you need anything else.

this should work:


select p.products_id, p.products_model, p.products_quantity, pd.products_name from products p, products_description pd where p.products_id = pd.products_id and...

yes, DO NOT change that password right now..

sorry, when I login to most cpanels, then access phpmyadmin, it automatically logs in. if you're being asked for a username/password at that point -...

one word of caution - not at all meant to scare you away. be careful in phpmyadmin. what you are doing is just a simple "select" query, which WILL NOT modify, add, or delete any information from...

So sorry for your loss.. Most of the reports or solutions you will find are going to require you "installing" or editing some files. While it's usually a pretty simple process, you might not be...

you've got a typo..

Firstly, when you're outputting your results - you're not looping through the results.. you'd probably want the output inside of something like:


while (!$products_stock->EOF){
//do something...

not sure if you're doing something different, but running that command will in fact truncate the existing entries down to 35 characters.. you might want to make sure you didn't just chop off half of...

don't have time to test right now, but something like:

select DISTINCT customers_email_address, customers_id, customers_country from orders where customers_id NOT IN (select DISTINCT...

not quite sure about that one - I think we're nearing the end of my expertise.. (or lack thereof) :blink:

I tried it on my end, and using your method, got the same goofy results.. This isn't a...

we've edited the minimum order amount to be disabled if you're logged in as admin.. you could do something similar for a specific user..

in the file...

your results may vary, but this seems to be working on a few test shops i've tried:


select DISTINCT customers_email_address, customers_id, customers_country from orders where customers_id NOT IN...

My first suggestion would have been to try easypopulate, but sounds like you're having trouble getting that working. (we routinely do imports for 6000+ items, so I feel your pain, but thankfully...

if you go into the live store admin, look at configuration->gzip compression. is it set to 1? if it is, you can either:
change it to 0 (disabled). Then export database from live site. Import...

do you have gzip compression enabled on your live site? one of our sites does, and when i import db into xampp i always forgot to turn it off, thus throwing the "unsupported compression" error. ...

you're certainly welcome (only gonna say it once though.. :D)

Another Joe

i'm not familiar with that particular template, but if it has column grid layout correctly installed you should find the options in the admin under:

configuration->product listing->Product Listing...

i've found over the years that once in awhile easypopulate will throw a product or two in the top level category (older versions anyway). Normally it should error out and say "no existing category...

I've experienced this behavior when we had a product in our root level category..

look at categories/products in your admin - is there a red warning about products in top level categories? if...

yes, in the new 1.5 version - modules have to be "registered" before they will appear on the admin menu. if you run these queries on your db vs a fresh test db, you'll see what you need to have in...

I wouldn't add the extra confusion of an upgrade into the mix until you get this sorted. If you don't want to start fresh, you can use a compare program to find what files are different from your...

You've got me confused.. first, what version are you using?

v1.5 comes with Admin Profiles already installed (now referred to in the menu as Admin Access Management).

In previous versions,...

I would start by looking at the includes/configure.php file, to ensure the paths are correctly defined. if you post the contents (without db username and password) we can probably tell you if...

assuming you have access to your web hosting company's cPanel, you can create cron jobs to run automatically and create site backups. they are fairly simple to create, if you google "site backup...

DrByte - I'm not sure I understand.. from what I gathered, the OP has their site installed locally to test before deploying to live server. Are you suggesting that a domain name should be used for...

if it's working for you, great - but I certainly wouldn't recommend mucking around in the configure.php too much, seems like that's just asking for trouble..

I simply access the site from the...

Not sure if maybe you were just typing the password incorrectly for the admin, but i'm able to access our local test site from another computer on our network - using the same scenario you described:...

if you have access to phpmyadmin, navigate to the "configuration" table, find the "DOWN FOR MAINTENANCE" row, and change the value from false to true. or, you can run this sql command from...

i n c l u d e s / v e r s i o n . p h p

it's been awhile since I made that change, but I believe if you go into includes/modules/pages/contact_us/header.php and look for this line:
zen_mail($send_to_name, $send_to_email,...

you could change it to this:

define('HEADING_TITLE', 'Welcome to ' . STORE_NAME . ', blah blah blah'); /*Replace this line with the headline you would like for your shop. For example: Welcome to...

find the file includes\languages\english\modules\shipping\storepickup.php
save a copy to includes\languages\english\modules\shipping\YOUR_TEMPLATE
open the file and edit the defines to read...

you'll need to look in your site's /cache folder - there should be debug logs that will tell you what's "breaking" the checkout_shipping page.. if there are a lot of them, just look at the last few...

i'm not familiar with that particular add-on, but the error is telling you the file permissions are not set high enough on the new files you added. you'll need to log in to your FTP or cPanel to...

you could modify the new products sql to omit any products with quantity = 0. (assuming you are using the quantity fields on products).

in /includes/modules/pages/products_new/header.php,...

thanks for the reply..



<rant> don't even get me started on what they don't understand. the whole thing is a joke. we've received false positives, spotted false negatives (comforting...

It's that fun time again, going through some pci scans with that wonderful company SM..

on this most recent scan they're complaining that the https pages don't redirect to http when the "s" is...

as DrByte suggested, I would get a clean copy of the original file from a fresh set of files.. drop that file in, and things should look normal again. then you can attempt to make whatever...

on line 72 of your tpl_header.php file you have:


<div class="headerTitle"><h1 class="shadow"><?php echo ; ?></h1><h1><?php echo ; ?></h1></div>

two empty echo's with a semi-colon after.. not...

yep, pretty sure it's new for 1.5.. there's a note in the config file "suggesting" you put them both to https for security, but it doesn't quite spell it out that it's a requirement for installing...

in 1.5 to run a payment module I believe you need to use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries.. making the entire admin https

one of our websites "hides" a large amount of items for a unique business need.. if you're going to get into the db editing, etc - I might suggest creating a custom field (or better yet, maybe...

if i'm understanding your question correctly, basically you would just change the product id for each product. For example, if the link to a product in your store is...

what happens if you change to this: (not an expert by any means, but my custom fields and all other fields on page use $pinfo->xxxxx instead of $pinfo->fields['xxxxx']


<tr>
<td...

yep, i was pretty much thinking the same thing when it came up..

only thing i can confirm is that upon removing those attributes (on a local test site), firefox immediately begins asking me to...