Let me ask this..
Are you sending apache a running list of things imported? Im now at a point where apache is outrunning the DB un CPU use.
How about also an option to output import...
Type: Posts; User: gemohler
Let me ask this..
Are you sending apache a running list of things imported? Im now at a point where apache is outrunning the DB un CPU use.
How about also an option to output import...
Still I cant find ANY reason why apache gets so wrapped up in the import process.
The file is on disk
Nothing is in the access or error logs..so..clicking "import" does nothing to apache.
I...
I dont write code..but if I did..
I would set a variable that says "Logs are not initialized" at the top
Then in the section at line 56, use isset to see if the variable exists. If not, continue...
I have not changed any DB characteristics, just a few missing index here and there that have helped..or seemed to have.
Ya..I think what I will do is create root categories based on part number bases.
1xx will be Category "100"
And so on, including A-Z. Easy enough to do.
Apologies, latest current code.
The N value is always 1..just as I add products a lot of entries really fast fall in here...and I'm working to optimize what I can in the DB without breaking...
Question #2:
This is identified as a 'slow query' on my machine"
'SELECT ip_address from admin_activity_log LIMIT N'
its a very long table..ans as I import products it gets larger...faaaaast.
Lets say I have 250,000 products.
And right now they are all in one Category (just testing)...
And it can be 'slow' to click on a single product.
Would be 'faster' if I broke up the products...
I'm acting as a drop shipper for a warehouse, so I dont want to show Qty to the customer.
It's assumed in stock unless the customer is later notified that it is not.
[Note: remember to include site URL, ZC version, list of plugins, PHP version, etc ... read the Posting Tips shown above for information to include in your post here.
And, remove this comment...
"If it has been updated to a value of zero and the box shows on the catalog side for the product then the issue is template related and not database/EP4 related."
This is in fact the case, TY.
Just change those two instances in easypopulate_4_import.php?
Simple enough. Was this having any impact other than a massive error log file?
I have this defined in the config:
User Defined Products Fields v_products_qty_box_status. (I have also tried this without v_)
I have this in my CSV:
v_products_qty_box_status
0
The one...
THIS file had this issue. Everything after it failed.
I took the data from THIS spreadsheet (except the header row), and put it in another one that did work (under it's header row)...and...
Right on..
I may have got the text backwards, but the excel file is in the order of the import results.
On the lookout for things I need to know as I relearn the ZC environment.
Im doing EP4 imports, and I have a log file getting _hammered_ with this (attached)
Ya..I mean, it doesnt break anything, but 75% of a CPU for apache2 is...busy.
Yup, testing mode. Got my first 150k products uploaded.
Can I log DB queries that occur in my store as I "use it"?
General EP question.
While doing a large import, apache is taking a lot of resources...
What is the WWW server doing during an import that makes IT so busy?
And then this happens.
Saved from open office, no changes other than a few 100k things added to the spreadsheet.
In this example, row 1 works.
Row 2 does not work.
They are functionally...
Duplicate. :(
Last question, then I have a lot of other work to do.
How do I set "No, Do not show Quantity Box" in EP?
And yup, those 5 worked..and a test of 5600 more just fine.
TY
The values are the same except for #Records that I increased. (Ill be doing massive uploads and I have bare metal and resources)
I just made the change to "language_id_only"
And THAT works. ...
New again user...
Got ZC installed, EP4 installed..no hiccups.
Formatted my CSV file from source data from a Shopify workflow, and ready to imports...cant:
Filename: ZC1.csv
SKIPPED! -...
*nod*
I've been poking around at my suppliers own inventory search/store tool...and about the worse case I've found so far for shipping something with weight to it, is a full set of wheels.
...
Hello all, old user coming back in from the dark..been gone from ZC for _years_.
Who has a store that does NOT charge shipping when I place an order, but after a dropshipper tells you what it...
In configuration/Easypopulate...
I have no settings to change, just the column header of Title/Value/Action.
ZC1.5.1
The VERY latest EZP version for 1.5.1
Server OS: Linux...
Is there a comparison of the different CC merchants that I can pick?
Paypal is nice, easy...reliable.
But, Ive had some problems with some overseas customers using the Paypal CC system, and ..I...
In the broken english of our exchange student "How are I to do this?"
Linda:
Just processed a new order, where the manufacturer that drop ships it has it as a 12lbs box going residential to Colorado Springs, CO 80918, and this also has insurance for orders over...
United Parcel Service
Enable UPS Shipping
True
UPS Pickup Method
RDP
UPS Packaging?
CP
Im finding that the UPS module isnt very accurate, at least when I compare my warehouse shipping cost, to what ZC determined.
Im up to $6 in 'handling' fees to be on par..so..how does this built...
Got it..
<td style="background-image:url(images/hawk-bg-image.jpg);background-repeat:no-repeat">
<?php include ('header_code.inc.php'); ?>
</td>
Hope this helps...
Im trying to execute a PHP script from within a table cell.
..I can do that, works great. Or I can define the PHP script with no image, and that works great as well.
Then..i want to add an...
It doesnt mean that it has to be very large text, or a graphic image, or a very busy/intense element.
Im just looking for a way to make some use of that real-estate, and the 'how' is where I am...
Image: http://www.speedtoys.com/~gemohler/window.jpg
Imagine if the text elements I added to the right and left, could also be graphical..basically, what can be done to make the background...
This is the CSS for my background:
body {style.css (line 1)
background:transparent url(../images/back.gif) repeat scroll 0 0;
margin:0;
padding:0;
text-align:center;
vertical-align:top;
}
1) Yes, chmod was done.
2) SSL is coming as soon as the new hosting people have done the migration..already on order.
Yup..theyre here:
googlecheckout/logs
I worded that poorly..
Im getting returned to my shopping cart, but there are no entries in these logs afterwards.
Does google checkout have a log file?
When I submit the order, I get bounced back to the shopping cart..and do not know why...
Thanks.
The next version...
Good god...thats great news. :)
I will have well over 100,000 products online pretty soon in the new store, I had about 356k in the old one, but have optimized product...
Things work when I use the classic template.
But..I still dont get how the same template works for some products, and not others when they all share the same attributes.
Other uploads means..when I use EZP to upload the different product brands, or lines.
I do nothing different for each of the category types..but I am getting different results in the store...
No..no difference.
It works everywhere in pads, but nowhere in fluds or brake kits...first page or results, or second, with/without the sort flag added to the URL.
I have no sort order set in...
I could accept that, if it was like that everywhere.
Buy brake pads..works fine.
Oil or Brake kits..no work.
??
ZC1.3.8a
http://www.e-brakes.com
Cannot...enter a quantity to purchase, then hit return to purchase SOME products.
??
An Example:...
Greetings...
ZC1.3.8a
Google Feeder 1.7.0a
I got this installed and I think its all right..but..
Out of about 30,000 products in my store, the XML file is only ending up with about 4400...