*A1*

Members
  • Content count

    21
  • Joined

  • Last visited

Community Reputation

0 Neutral

About *A1*

  • Birthday 07/22/1960

Profile Information

  • Real Name
    Fred
  • Location
    Netherlands

Contact Methods

  1. Support thread for the report contribution products_searches V1.0 This contribution takes keywords in catalog/advanced_search_result.php and stores them in the database. The keywords includes the customers_id so you can keep track of what your customers/visitors/guests are looking for in your webshop. in admin/stats_products_searched.php under reports you can see what yuor customers were looking for in your shop. http://addons.oscommerce.com/info/8365
  2. PLS. help out because I can't find the solution. I have 2 shops running in with 2 domainnames. www.shop1.nl and www.shop2.nl I have one hostingaccount at my provider. Shop1 was the first and works fine for several years now. Recently I wanted to add another shop to this account. I installed it in a different subdirectory and that worked fine too. The public_html has an .htaccess file directing www.shop1.nl to dir1 and www.shop2.nl to dir2 Then I installed Ultimate Seo Urls 5 Pro. Both work fine but on shop2 the sitemap generator doesn't produce the right files. When I switch off the SEO in admin it works So I think it has something to do with the rewriterules in the .htacces file of shop2 my .htaccess file is as advised in the installation documentation. # If you are getting errors you may need to comment this out like .. # Options +FollowSymLinks Options +SymLinksIfOwnerMatch <IfModule mod_rewrite.c> RewriteEngine On #RewriteRule ^/*(.+/)?([^.]*[^/])$ http://%{HTTP_HOST}/$1$2/ [L,R=301] # RewriteBase instructions # Change RewriteBase dependent on how your shop is accessed as below. # http://www.mysite.com = RewriteBase / # http://www.mysite.com/catalog/ = RewriteBase /catalog/ # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ # Change RewriteBase using the instructions above RewriteBase /shop2/ RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-m-([0-9]+).html$ index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pi-([0-9]+).html$ popup_image.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pr-([0-9]+).html$ product_reviews.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-pri-([0-9]+).html$ product_reviews_info.php [NC,L,QSA] # Articles contribution RewriteRule ^([a-z0-9/-]+)-t-([0-9_]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-au-([0-9]+).html$ articles.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-a-([0-9]+).html$ article_info.php [NC,L,QSA] # Information pages RewriteRule ^([a-z0-9/-]+)-i-([0-9]+).html$ information.php [NC,L,QSA] # Links contribution RewriteRule ^([a-z0-9/-]+)-links-([0-9_]+).html$ links.php [NC,L,QSA] # Newsdesk contribution RewriteRule ^([a-z0-9/-]+)-n-([0-9]+).html$ newsdesk_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nc-([0-9]+).html$ newsdesk_index.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nri-([0-9]+).html$ newsdesk_reviews_info.php [NC,L,QSA] RewriteRule ^([a-z0-9/-]+)-nra-([0-9]+).html$ newsdesk_reviews_article.php [NC,L,QSA] </IfModule> Base is /shop2/ again all is working fine but the rewrite rule mess up the sitemaps. When I switch off SEO it makes the correct files except the url's are plain instead of the url produced by the SEO program. Search engines don't like sitemaps with url's that are forwarded so I like to have it correct. I hope I'm clear enough in describing the problem. Anyone knows how to adjust the rewrite rules so everything is working the way it should? Thanks for your help Fred
  3. Jan, you're the BEST. it works. I changed PriceFormatterStore.php to // customer group price can be NULL so use retail if empty // if ((int)$new_prices[$i]['products_price'] > 0 ) { if (is_numeric($new_prices[$i]['products_price'])) { $product_info[$x]['products_price'] = $new_prices[$i]['products_price']; } I tested also with a customer_group price of 0.00 and that works too. The price stays 0.00 instead becoming retail price. When customer_group price is ommitted it becomes the retail price. THANKS!!!!
  4. I've found something really weird in de QPBPP mod. I tested a lot to minimize the situations in which cases it fails. I added a product with a price of 2.50 (Retail) The price for customer_group 1 is 0.99 In product_listing.php en product_info.php the right price is shown. When I add the product to the shopping_cart the price changed to 2.50 (Retail price) In product_listing.php, at the end of the addition for QPBPP (around line 240) I added an echo statement to see what the values of the variables became. The initial values are: Which is correct. After adding the product to the shopping_cart the values changed to The price in the shopping_cart becomes 2.50 too It only happens in case the price of customer_group is lower than 1.00 If I change the retail_price to 0.70 and the customer_group price is 0.99 the price becomes the retail price (even when it is lower) So in case the customer_group price is lower 1.00 the price will always chang to the retail price if the price has a special_price everything looks ok. If the customer_group price is 1.00 or higher everything looks ok too. So as far as I can see the fault only happens in case a customer_group price is lower than 1.00. Now I'm stuck because I'm not sure where the price alteration happens. Please help me find the solution.
  5. I like to offer selected customers the option to use a payment module INVOICE. By adding a column customers_invoice in TABLE_CUSTOMERS I can select customers who are alowed to pay by invoice. if I change the selection function in the payment module to function selection() { $invoice = tep_db_query("select customers_invoice from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $invoice = tep_db_fetch_array($invoice); if ($invoice == '0') { $this->enabled = false; return false;} else { return array('id' => $this->code, 'module' => $this->title); } } if I change the if statement to if ($invoice == '1') than the module is shown. So it looks like the value of $invoice = 0 always even if I change the customers value to 1. Obviously the value of $invoice isn't the value of customers_invoice of the selected customer. How do I change the query to make it selecting the current customer?
  6. first:I use easypopulate with great pleasure. thx to all who worked on it.. I uploaded thousands of products in my new shop and it all work fine until................ I wanted to update a large amount of products with a v_products_description. I used only 3 fields v_products_model, v_products_description and EOREOR when I run easypopulate it tells me it updated the records but it didn't. I read the manual and I couldn't find anything about minimum fields to update. I also read the bug reports but couldn't find anything about this. Is anyone aware of this problem or knows where I can find the solution please let me know.