Jump to content

iLLuSiOnS

Members
  • Content count

    82
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Sean
  1. Hi, I installed easypopulate 2.76h successfully and followed the instruction to the dot. The problem I am having after I do this is: When I click on the "Quick Links" > "Download COMPLETE .csv file to edit" it gives me this error: but when I click on the "Export EP or Froogle Products File" and try to export a "COMPLETE" download, it creates a file for me and when I open it in excel, there are no products eventhough I have many products in my store, except it has one line that says: <font color="#000000"><b>1054 - Unknown column 'products_options_name' in 'field list'<br><br>select products_options_name from products_options where products_options_id = '1' and language_id = '1'<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font> I believe this to be a problem with my attributes because when I do a custom download and check everything except the "attributes" box it downloads my store perfectly with all the products, the moment I check the "attributes" box it gives me the same error <font color="#000000"><b>1054 - Unknown column 'products_options_name' in 'field list'<br><br>select products_options_name from products_options where products_options_id = '1' and language_id = '1'<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font> Can someone please help. Thank you
  2. Hi, I will pay $20 paypal to anyone that will make my easypopulate work. At the moment, since I have creloaded 6.2, its running easypopulate 3.01 which exports the attributes as a separate file, and only allows you to upload the attributes as a separate file, so I need it working so that it will export and import all in one file I really really need this badly. Thank you Thanks
  3. I dont really want to use that version, I would like to use the most updated (2.76h) but wondering if downgrading would pose any problems, there are no real downgrade instructions. Thanks
  4. Can no one help me with this? Please Should I just reinstall the latest version of this contribution, will that cause any problems? Thanks
  5. I have a quick question to a problem I am having. I have installed oscommerce, well actually it is creloaded 6.2 and it comes with easy populate 3.01, but looking in the contributions section, easy populate is only at version 2.76, so how do I have 3.01? Now the problem I am having is, in previous versions of easy populate (2.75) When I exported either with basic or advanced, it would give me attributes in the same file, but now with 3.01 I have to upload the attributes as a separate file, I have to click on data manager > easy populate advance > options export I tried putting the attributes in the same file as the products information, and it gives me and error 1054 - Unknown column 'products_options_name' in 'field list' select products_options_name from products_options where products_options_id = '1' TEP STOP Can anyone clarify this for me? Thank you very much
  6. I am deeply in need of some help. I need to be able to show the products description on the printorder, invoice, and even the account history info. How can i call for the description to be added to these pages? Thanks in advance
  7. I have installed chemos script a hundred times with no problems, i installed it yesterday and categories work fine, but the products page firefox gives me this error (page isnt redirecting properly) because i think there is something wrong in the url (amp) product_info.php?amp;products_id=1&osCsid=a927020497a918be862bdb2d401f5936 and does anyone know how to get rid of the csid? i think its because i have "force cookies" disabled, but if i enable it, no one w/ disabled cookies can access the site correct? What is the recommended value for "force cookies" enabled or disabled? Thanks
  8. I have searched all contributions but cant find the right one to do what i want. I am a service company and offer mostly services, and I usually service a customer first then invoice later. is there a way i can create a order and give it a status like "awaiting payment" and that customer get a email saying they owe $$$ and they click on a link, login to their account and they will have a invoice which will require them to pay now. Thanks in advance
  9. I want to integrate a domain name purchase option, but would need different information from the client then the information I need from them buying regular products. I dont want my domain name (or hosting) customers to have to fill out shipping info, but need additional information (like dns names, ip addresses, etc) to be filled out, but dont want to bug the regular products customers to fill out that info. Any suggestions?
  10. iLLuSiOnS

    Domain name registrar

    Hi, I would like to add the ability to sell domain names on my site. The best contribution that allows this is the domain search contribution, but i have a problem with this. The contribution adds the available domain name that the customer has searched for availablity and adds it to their shopping cart like a regular product, then allows them to checkout. The problem with this is, domain name registration requires a bit more information from the customer then a regular product. And when my site asks the domain name customer for their shipping address, i think they will be very confused My question is, is there a way of giving the domain name customers a different registration form, and one that doesnt require them to put in their shipping address or will i have better luck going with a complete different domain name registration system for my site , like a prebuilt one from hotscripts or something. Thank you very much
  11. I want to be able to export Customers data and order/invoice data all in one file so i can integrate it into my accounting software (Microsoft accounting allows csv imports) I see there are a few customer exports and other invoice exports, but im planning on doing this everyday and dont want to export 2 separate files, is there a contribution that allows both customer data and invoice data to be exported into one file? Thanks
  12. iLLuSiOnS

    Ebay Contribution

    I want to expand my website into ebay. I want to start selling on ebay, and when they check out, i want them sent to my site and my shopping cart to handle the transaction. So they will have to create a new account with my site. Whats the best ebay Contribution? And when they are sent from ebay to my site, will there name address and all that info be brought over with them so they dont have to reenter it on my site? Thanks
  13. I am having trouble, when i create new subproducts it lists all the sub products in 1 column, one LONNGG column. Is there anyway i can make it into 2 or 3 columns? This is the code that needs to be changed. // MOD begin of sub product $sub_products_sql = tep_db_query("select p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_parent_id = " . (int)$HTTP_GET_VARS['products_id'] . " and p.products_quantity > '0' and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id); if (tep_db_num_rows($sub_products_sql) > 0) { ?> <tr> <td align="left" ><table> <?php while ($sub_products = tep_db_fetch_array($sub_products_sql)) { $subname = substr( $sub_products['products_name'], strlen( $product_info['products_name'] . ' - ' )); ?> <tr > <td style="padding-left:50px;" ><?php if ($sub_products['products_image']) echo "<img src='images/" . $sub_products['products_image'] . "' />"; ?> <br> <b><?php echo $subname; ?></b></td> <td align="right" class="smallText">Qty: <input type="text" name="sub_products_qty[]" value="" class="input3" size="1" /> <br> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_template_image_submit('jh', IMAGE_BUTTON_IN_CART); ?></td> </tr> <?php echo '<input type="hidden" name="sub_products_id[]" value="' . $sub_products['products_id'] . '">'; } ?> </table></td> </tr> <?php } // MOD end of sub product
  14. iLLuSiOnS

    Payment Modules in Admin

    Is there any way i remove paypal and have oscommerce not use the paypal module.
  15. For some reason, sub products only get listed in one long column, how would i tell it to load in multiple columns. Thanks /////////////////////////////////////////////////////////////////////////////////////////////////////////// // MOD begin of sub product $sub_products_sql = tep_db_query("select p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_parent_id = " . (int)$HTTP_GET_VARS['products_id'] . " and p.products_quantity > '0' and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id); if (tep_db_num_rows($sub_products_sql) > 0) { ?> <tr> <td align="left" ><table> <?php while ($sub_products = tep_db_fetch_array($sub_products_sql)) { $subname = substr( $sub_products['products_name'], strlen( $product_info['products_name'] . ' - ' )); ?> <tr > <td style="padding-left:50px;" ><?php if ($sub_products['products_image']) echo "<img src='images/" . $sub_products['products_image'] . "' />"; ?> <br> <b><?php echo $subname; ?></b></td> <td align="right" class="smallText">Qty: <input type="text" name="sub_products_qty[]" value="" class="input3" size="1" /> <br> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_template_image_submit('jh', IMAGE_BUTTON_IN_CART); ?></td> </tr> <?php echo '<input type="hidden" name="sub_products_id[]" value="' . $sub_products['products_id'] . '">'; } ?> </table></td> </tr> <?php } // MOD end of sub product ///////////////////////////////////////////////////////////////////////////////////////////////////////////
×