PupStar

Hi Kelly, To run the sql you need to go into your database through your control panel. You then run the sql statements so they are loaded into the database. Mark

ok finally trying to get back to this problem to get it sorted. I have read about other carts versions of easypopulate that populate the database by the products_id and not the products_model. The reason I do not want to change the way it works as suggested above is because I would need to rewrite more code in the admin for the way my parts manager system works. So to all who use EP have you managed to find a way to import by products_id rather than products_model. Thanks Mark

Unfortunately I will not share this with the community as if it were to be released then everyone would make money using my supplier and interface but not me >_< If you let me know which supplier you are using by pm I am willing to take a look and see if there is anything I can do. I am in the process of porting it to another suppliers xml feed however it will be near enough a rewrite to cope with the different xml tags. As G said Easy Populate is a good free solution if your supplier has a csv file and you have the time to download and reupload all of the product images. If your supplier does not supply a csv file then you could take the xml and convert it to csv.

What sort of feed are you supplied with as I have one supplier that generates an xml feed on the fly and I have a coded an xml import interface with allows me to select which categories of products to import, set individual prices per category by adding a percentage to the cost price. This is all done using temporary tables in the database which once sorted I can press a button and transfer all products to the live store, oh and it also imports all images. Mark

which contribution have you added? Post the link and then I cna advise accordingly.

Try EasyPopulate

Hi Jack, I have installed version 3.2.5 I do have a few errors which are being reported by KissER Error Handling Although not directly related to Header Tags there is a conflict somewhere. Any ideas? Thanks Mark

Well I use Information Pages Unlimited with 2.3.1, there a couple of things that need changing but the install is pretty straight forward. Regards Mark

Hi Jack, I have this working great, but to bring it into line with the new admin buttons I am trying to change this code <td align="center"><?php echo (tep_image_submit('button_update.gif', IMAGE_UPDATE, 'name="update_form"') ); ?></td> the bit I am struggling with is where to place the 'name="update_form"' into the tep_draw_button. Regards Mark

Hi, I am trying to integrate this into 2.3.1 which has QTPro installed and I am struggling with adapting the following line $out.='<tr><td align="right" class=main><strong>'.$attributes[$o]['oname'].":</strong></td><td class=main>".tep_draw_pull_down_menu('id['.$attributes[$o]['oid'].']',array_values($attributes[$o]['ovals']),$attributes[$o]['default'], "onchange=\"stkmsg(this.form);\"")."</td></tr>\n"; to incorporate this line from the manual installation txt file. echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute,' id="cmbooption_'.$opt_count.'" onChange="getPrice('.$product_info['products_price'].','.(int)$HTTP_GET_VARS['products_id'].','.$all_option_js.')"'); ?></td> Any help would be appreciated. Thanks Mark

Glad you did this as it turned out to be ideal for the site I am working on. :thumbsup: Any ideas on how to remove the link to the top level category if it has subcategories. I only want the link on the top level category if it does not contain subcategories. Thanks Mark

whats wrong with using http://addons.oscommerce.com/info/7725 ??? Mark

I suppose I could but I would really like to keep the way osc works the way it is unless I am missing a trick. It cant be that hard as I am pretty sure cre works that way. Mark

hi guys, I now really need suggestions on how to import by product_id and not model number so I can have several product_id's with the same model number. I have being messing with the easypopulate code but with no success. Thanks Mark

do you have a url so we can see what you mean?

What I mean is if I modified easypopulate so instead of the first column being products_model but products_id - would easypopulate use the products_model field as the key field for updating the store. The reason I need to update by products_id is because I am creating an online parts system with exploded diagrams and the same part can be in different categories but with the same model number, the problem arises because I am using unique reference numbers on the exploded diagrams which correspond to the product so I have multiple products with the same model number. Mark

I was just wondering does easypopulate use the products_model because its the first column in csv and would it update off a different column if I say added a products_id column??? Mark

ah right, I never new thats what they were called

whats a QR code???

Hi, I am in a same situation as Ronald who required the fix below however my need is slightly different ;) I have done the steps below and all good so far apart from I have an extra rule that needs applying. I have a field in the database called 'products_restricted_status', if this is set to 1 then the product will not be allowed for sale and if it is set to 0 it can be purchased. I added to the line in product_info.php if ($master_check['products_master_status'] > 0 || $master_check['products_master'] == 0 || $master_check['products_restricted_status'] = 0) { But this still does not allow the product to be added to the cart. Any ideas on how to sort this? Do I need to change the 'add_slave' code in application_top???? Thanks Mark

Sorry I have never used Vstore. Do they allow you access to the database via phpmyadmin? Mark

ok I have been looking into santizing the url but with no great results. It really needs to be done when the 'Find' button is pressed. Has anyone done this sort of thing before? Thanks Mark

I have done this several times and everytime I follow the rule of search for v_products_weight and where that appears add my new code after it. If you do that then you should have no problems. Also remember to add your new fields to the database. Regards Mark