Thanks for all your advice DrByte.
Yes I am aware that the second query will update all 0 status products, but this is my intention because I am not wanting to sell the 3000 surplus products so I...
Type: Posts; User: AndyVI
Thanks for all your advice DrByte.
Yes I am aware that the second query will update all 0 status products, but this is my intention because I am not wanting to sell the 3000 surplus products so I...
Not importing 3000 every hour, there is already 3000 in zencart database.
Probably 95% of my products are already listed in zencart from previous imports.
The importer searches for existing...
Thankyou 1000x for the heads up on the potential Product ID problem, i hadnt thought of that and would have just gone in like a bull in a china shop.
I have thought of using the product_status...
I havent approached the Vendor because the software itself and the import functions are working perfectly and doing exactly as we require.
Let me clarify what Im trying to acheive:
We have 5000...
Hi there,
Many thanks for your replies and suggestions, we are using Mag neti cOne's store manager to controll the category / product structure and imports.
(At present the stock levels from...
Hi there,
As the title suggests, I am trying to delete certain products in bulk from my store.
For example, I want to delete all products where products_status = 0
Im fairly sure I cant...
Sorry but I need to Bump this :)
better still make a folder in /html_includes with your "template" name, and copy the file to there.
Go To :
httpdocs/store/includes/languages/english/html_includes/classic/define_main_page.php
via your FTP and edit the file manually :)
Yes your correct on the "Advanced Search" page they are able to define a Manaufacturer to search in.
However if the user just uses the search sidebox and enters "banana" for example then it...
Sorry to bump, but im several hours on and no further to acomplishing this...
Someone must know how to do this, the code is already in zencart and working perfectly when in a category.
Hi there, on my site my customers are relying heavily on the search function to find what they are looking for.
When in a category there is a dropdown form where they can filter down results by...
OK I think ive fixed it, but im fairly sure there is a more "on-zen" way of doing it but heres the code I used :
<?php
if (isset($_GET['filter_id'])) {
$manid = $_GET['filter_id'];
echo '<a...
Hi there,
Im trying to add a button to my categories to filter by price ASC and DESC.
Im using
<?php
echo '<a href="' . zen_href_link(FILENAME_DEFAULT , "cPath=$cPath") . "&sort=6a" . '">'...
Hi Mike,
Thanks for your reply.
Many thanks for that link kobra, the site is on a dedicated server I have since updated the php to PHP Version 5.3.6.
Still experiencing problems with PHxx...
Hi Zenned,
Many thanks for your continued support, here are the details of my installation as requested:
What PHP version is your installation using?
PHP Version 5.1.6
What server type -...
Hi Zenned,
Im still having difficulty with this, I have updated to your "Bug Fixed" version.
However it does not seem to have made any change to the problem we have.
The following postcodes...
Hi Mike,
Thanks for your quick response.
I have thoroughly read the readme and have double checked everything.
I have tried:
removed white space (not working)
removed ampersands and...
Hi Guys,
Cool module this is exactly what I need for a site im developing.
However I have a problem...
The module is installed and seems to be working for most postcodes, however some of the...
Trouble is how do I search for nothing to replace with nothing?
Also the actual images already have the .png extention, it is just the CSV file that is missing the file extention.
Just an idea,...
Hi there,
Ive tried using Excel to add the suffix and got it working as you described.
However, the cell is formatted weirdy, it appears there is a space between my file name and the extention....
Many thanks DrByte,
I will look into these solutions.
Kind Regards
Andy
Ah many thanks...
I knew it would be possible in excel just didnt know how, so thanks for the solution :)
------------
However this is not the most ideal solution for me, I am updating my...
Hi there,
im loading 80,000 products from a CSV file but in the file the images are missing the file extention .png
All of my product images are .png files so I was thinking the easiest way...
hahaha... sorry, i dont know why i didnt think of searching :)
Many thanks...
Hi there,
Im searching high and low for a product filter to sort products by "Size, Colour, Design" etc. (not attributes!)
Ive added 3 extra fields into the "zen_products" table and its working...
Hi Kobra,
Yes that is a possibility, however we import and update the site stock levels every 3 hours automaticly, and have 15,000 active products.
To do as you described would mean literally...
Hi there,
Im importing my products from a CSV file (67,000) in total, however within my CSV there is 4 different entries for each product because of different stock levels / stockist depots.
Is...
Hi Kobra,
Thanks for your reply, I did think of using attributes however I am importing my products from a CSV file.
I have over 87,000 products imported, so manually setting up attributes for...
Hi there,
Ive been looking for an add-on to perform this but havent found any as of yet.
Basicly when a customer is looking at a products I would like to have 4 different Buy Now buttons, each...
This is what I done and it worked fine first time:
Check : http://www.zen-cart.com/forum/showthread.php?t=57924&highlight=extra+product+information
Ah yes that did the trick!
Thankyou 1000 times Ajeh :)
The final SQL commands I made were :
UPDATE `products` SET `products_price` = (`products_price` * 1.05) WHERE `products_price` >=...
Hi there,
I searched high and low for a way to set a profit margin based on the product price.
For example if you are importing from a distributors stock list then you may need to calculate how...
I need a similar mod to this but based on price range markup
for example:
£0 - £20 = 10%
£21 - £30 = 15%
£31 - £100 = 20%
How would I go about defining a price range and % for each?
I installed the mod hoping it would do the same, I need a sitewide markup % by price range so badly.
Any ideas, surely this mod can be slightly edited to accomodate this function.
Thanks... :)
Hi there,
Fantastic tool, just what I was looking for :) :) :)
However, im having difficulty uploading large CSV files..
I have over 87,000 products in a CSV of about 33mb... but when I go...
Sorry to bump this thread, but was there ever a solution or code made for this?
This would be an awesome and useful tool.... :)
Hey Stuff4Toys,
Thanks for the reply, I am aware of Easy Populate but wasnt sure if a 3rd party / distributors list would work.
So basicly without editing the CSV file to make it compatible...
Hi there,
I Have got a question and hope someone can point my in the right direction.
(Im using the latest / clean install of zen cart)
Ive been asked to setup an online Tyre shop, where...