February 25th, 2010
Google Base Products (Froogle)
Recently, I tried to use current Froogle Feeds in Tradingeye (both v5 & v6) to products into Google Product listing service (http://www.google.co.uk/products). However, there is still a little buggy and limitation of this feed as it exports all products under text format.
I noticed a fact not all of your products are added to Google Base Products. Besides, product short description is being treated as product description, so if a product does not have short description then it would not be added to Google Base at all !
Okay, we have created a new script to export all product d
etail into a RSS feed (XML file format) with the following attributes:
- Product Title
- Price
- Department name (New)
- Product ID (using Sku code + ID)
- Image URL
- Product URL
- Product condition
The script can be used for all Tradingeye and UK2 ecommerce users.
How to use it:
- Download the zip file
- Replace your froogle.php file in scheduler/froogle.php with the on in .zip file
- Open up the new froogle.php and read the instruction
Download:
Commercial supports: please get in touch with Quay Creative at info@quaycreative.com.
Froogle Feed - Google Based Products (4)
Categories: PHP, Tradingeye & UK2 Ecommerce, Web development |
No Comments
December 4th, 2009
Most of you have created few test transactions with your ecommerce website (Prestashop) when building it. By the time you decided to delete / clear all test orders in Back Office but wonder how as no “delete button” available.
The solutions is very simple
Option 1:
Click on one of the order and replace the parameters “vieworder” by “deleteorder” from the url
For example
http://yourdomain.com/admin/index.php?tab=AdminOrders&id_order=7&vieworder&token=798dfd720021761c80d828eb3f2a8621
Change it to:
http://yourdomain.com/admin/index.php?tab=AdminOrders&id_order=7&deleteorder&token=798dfd720021761c80d828eb3f2a8621
Option 2: For the sake of PHP
Go to AdminOrders.php class in webroot\admin\tabs\AdminOrders.php
At line 25 look for
global $cookie, $currentIndex;
And add this code below it…
That’s it.. when you click on “Order” main tab you will see the delete button “X” next to each order (screenshot)
Categories: PHP, Prestashop |
Tags: Prestashop, prestashop ecommerce, prestashop tips | No Comments
November 17th, 2009
Today small task for an ecommerce website is to look for all possible external images from supplier and download to our own server. We have thought of using @fopen() a common php function to open a file. However, there is more to find out.
< ?php
if (@fclose(@fopen("http://www.domain.com/image.jpg", "r"))) {
echo "External image exists";
} else {
echo "External image does not exist";
} ?>However, we soon realised that using fopen() does not work properly if the external website handle 404 page well, which mean if the image does not exist their server will redirect audience to an “notfound” page or to “imagenotfound.jpg”.
To resolve this problem, you can simply use GetImageSize() function from GD library.
< ?php
if (@GetImageSize("http://www.domain.com/image.jpg")) {
<code>echo "External image exists";
} else {
echo "External image does not exist";
} ?>
Categories: PHP, Web development |
Tags: external image, fopen, GD, GetImageSize | No Comments
March 10th, 2009
How to add pagination to product options in Admin ?
This customisation is for all UK2.net e-commerce package customers and Tradingeye users (5.04+)
Files need to modify:
modules/ecom/templates/admin/optionHome.tpl.htm
modules/ecom/classes/admin/option_interface.php
Edit the option_interface.php class as following steps:
1. Modify the c_optionInterface() function
Before edit:
#CONSTRUCTOR
function c_optionInterface()
{
$this->err=0;
$this->errMsg="";
$this->libFunc=new c_libFunctions();
}After edit:
#CONSTRUCTOR
function c_optionInterface()
{
$this->err=0;
$this->errMsg="";
$this->libFunc=new c_libFunctions();
#INITIALISING PAGINATION VARIABLES
$this->pageTplPath=MODULES_PATH."default/templates/admin/";
$this->pageTplFile="pager.tpl.htm";
$this->pageSize="50"; #NUMBER OF ITEMS DISPLAYING PER PAGE
}2. Modify the m_showOptions() function
Replace everything between these 2 parts
Part1(line 47):
$resOption=$this->obDb->fetchQuery();
$varCount=$this->obDb->record_count;
Part2(line 70):
$query= "SELECT * FROM ".CHOICES." order by vName" ;
By this code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
| #ADDED PAGINATION FOR PRODUCTS
$extraString ="action=ec_option.home";
$pn =new PrevNext($this->pageTplPath, $this->pageTplFile,$this->obDb);
$pn->formno =1;
$navArr =$pn->create($query, $this->pageSize, $extraString);
$resOption =$navArr['qryRes'];
$recordCount =$navArr['selRecs'];
$totalRecord =$navArr['totalRecs'];
$row1 =$navArr;
#BLANK OUT THE PAGINATION
$this->ObTpl->set_var("TPL_VAR_PAGINATION", "");
if($totalRecord>$this->pageSize){
$this->ObTpl->set_var("TPL_VAR_PAGINATION", $row1['pnContents']);
}
$this->ObTpl->set_var("TPL_TOTAL_RECORDS",$varCount);
if($totalRecord>0)
{
for($i=0;$i< $recordCount;$i++)
{
if($resOption[$i]->iState==1)
{
$this->ObTpl->set_var("TPL_VAR_CHECKED","checked");
}
else
{
$this->ObTpl->set_var("TPL_VAR_CHECKED","");
}
$this->ObTpl->set_var("TPL_OPTION_ID",$resOption[$i]->iOptionid_PK);
$this->ObTpl->set_var("TPL_VAR_TITLE",$resOption[$i]->vName);
$this->ObTpl->set_var("TPL_VAR_DESC",$resOption[$i]->vDescription);
$this->ObTpl->set_var("TPL_VAR_MESSAGE","");
$this->ObTpl->parse("dspstdoption_blk","TPL_STDOPTIONS_BLK",true);
}
} |
Edit the optionHome.tpl.htm template file as below:
1. Add line 16, add this code for the pagination
{TPL_VAR_PAGINATION}
Finally, make sure you replace 2 other files from the download ZIP
1. modules/default/prevNext.php
2. modules/default/templates/main/pager.tpl.htm
That’s it. Please note this modification is for Standard Options only. You can follow the same method to apply the pagination for Custom Option or even product listing under department.
Feel free to ask me any question.
Categories: PHP, Tradingeye & UK2 Ecommerce, Web development |
Tags: pagination-product-options, standard-option-tradingeye, tradingeye-customisation, uk2-ecommerce-bespoke-customisation | No Comments
November 25th, 2008
If you have problem with using PNGs images on IE6 then here probably is easiest way to fix the problem
Transparency issue with PNG in IE6
Step 1: Download the SuperSleight.zip file from bottom of the entry
Step 2: Extract the file and place these 2 files: supersleight-min.js and x.gif under your javascript folder
Step 3: Put this code below in between the <head> </head> tags
[code]
<!--[if lte IE 6]>
<script type="text/javascript" src="supersleight-min.js"></script>
<![endif]-->
[/code]
Step 4: You’re done! Click here if you want to know more how it works or even this one.
http://24ways.org/2007/supersleight-transparent-png-in-ie6
http://www.twinhelix.com/css/iepngfix/demo/
Categories: PHP, Web development |
Tags: 24-ways-ie6, png-ie6, supersleight | No Comments
