Here are the proper headers...
Type: Posts; User: drrogera
Here are the proper headers...
It does not help me - the link does not work and my guess is that instruction is for a different thing.
this is my last post to you - if you don't want to follow my advice - I will stop giving it....
As I said before, I don't see the headers, but maybe they re not needed. So , I tested that and when I tried to upload it - I got this error message
No model field in record. This line was not...
No headers to define the columns - is my first notice. Second, where are the commas. This is supposed to be a csv file.
That is my first observation - was the output a Tab separated list?
Without seeing the download and upload files, I can't say for sure what the trouble is - It may just be a column name issue but if you are getting it from a download then the columns should be fine....
Without the error message - I am not sure what to tell you to do.
Dave,
I did not copy your text because of the length - You have the problem that started this thread - Duplicate field
Column 'products_last_modified' specified twice
It is right there in the...
OK, now we are talking about 1.2.5.7 (not 8 right? 8 is sort of a minor fix to 7 I believe)
This is a very troubling set of errors - I have not encountered this. Are you sure you uninstalled the...
2 things Dave,
1) the version 1.2.5.5 has been discussed elsewhere (http://www.zen-cart.com/forum/showthread.php?t=134290) and I believe it was decided that it is better to stay with 1.2.5.4 which...
What I have done - is to take the original file that you create and then download to make my header row. I delete columns I do not use (You MUST have the v_product_model so keep that)
Also - this...
You're welcome.
You made my day! :clap:
The idea was to pickup any categories that had an active product somewhere below. So the idea was to get to the top as it were. I hope I got hat correct.
UNION queries are my favorite. When I see...
Here is a query that will return a list of categories that have active products and 4 levels above that those categories are subs to - how you choose to use it is your business. In other words, if...
Thanks for the save!
I am still wondering how the existing products which were in the database, if I understood the prior explanation, went missing? If they were added one by one in Zen Cart, it should have tossed an...
Once I was able to lay this out the problem is obvious, to me at least. That said, this issue is very clearly defined in the manual - What is the Primary Key?
Zen Cart, like most database driven...
Shaun,
What program are you using to edit the csv file? On what operating system. If you are using a MAC and Excel, that is a problem. It does not create the proper line ends. You have to use the...
That's just it - it's not a module so much as a way to fill the upload table that populates the products_options_values table. I will get the write up done this week and perhaps with a combination...
We have over 2500 products which may have as many as 40 attributes, several of which can have multiple values (14 in one case). I will post my work-around this week and I would be happy to know if it...
I guess I'll have to consider myself a non-novice then. :smile:
My main reason for moving to 1.2.5.6 - Attributes. I NEED them and use them extensively. For those who do not need to use them a...
I appreciate your thoughts but 1.2.5.6 works fine for me and with a few fixes 1.2.5.7 will too.
I just did a review of the changes - line by line comparison and there are a few things that bother me about 1.2.5.7
It looks like a replace all was done the changed most if not all instances of...
OK two problems
#1 I am using 1.2.5.6 so I was not getting the error. I'll fix that once 1.2.5.7 is fixed
#2 As I suspected, the error is in the SQL code of admin/easypopulate.php. I am not sure...
One more guess - hidden characters
In the past these have been my biggest problem. Some software does not show non-standard ASCII characters and Excel was really bad at adding them. One routine we...
Artisan -
#1 Thanks for starting a new thread. The others are getting long and are not for the csv versions.
#2 I am not including your text because it is so large.
If I remember my SQL...
:laugh: OK, I just made an override copy of the file, includes/modules/column_left.php; modified the SQL to skip the search box in the sidebox!
Original(line 15):
// Check if there are boxes for...
I am still hoping someone will provide an answer to #4.
I feel fairly competent with Zen Cart but I have been unable to keep the search in the "Main" area while having it go away in the sidebox. ...
I thought of one more thing to try and that was it. Look for places where the TEXT_TOTAL_AMOUNT is defined. That was the trick:
includes/languages/english/extra_definitions/cart_summary_sidebox.php ...
I don't want it to go away, I just want it to display correctly. What I have right now is:
Items: 6Amount: $575.00
What I would like is
Items: 6; Amount: $575.00
I have looked at the code and...
I am by no means a Zen Cart expert but I learned a lot while working with this mod to make it work the way I wanted to.
My first observation upon visiting your site is that it looks like you are...
For our product type (antibodies for research and diagnostics) we absolutely needed to have an attribute search that was able to "filter" on more than one attribute at the same time. I reviewed all...
It is working - thank you so very much. The funny thing is that I am not as interested in optimizing queries at this point as I was about seeing where my POST data was going. For some strange reason...
OK, went through file by file and found that some files just did not install. Now they are all in and - I see data but I also see this strange box at the top of the page
"[ Close ] Match queries...
I am not sure where I went wrong but after installing both Query_Cache and Query_Logger I see no evidence that either is working or installed. :dontgetit
I did see, after running the SQL patch,...
credenscel
Since EP uses the "part number" as the key you cannot have two items with the same part number in the database and it appears you are not trying to violate that you just want it to be...
Has there been a resolution to this issue of tax on handling but not on shipping?
Seems to me that it complicates setup but in the end, may be a necessary evil given that these are separate items...
Ok, I have spent hours looking for a solution to the problem of having Handling and Shipping displayed separately. :blush:
I tried inserting the code above (using 1.3.8 on a test site -...
The previous discussions where people had upload issues using an Apple computer that I could find all say you cannot use a MAC to create the file. The truth is: you cannot use Excel on a MAC but you...