Jump to content

lestatbp

Members
  • Content count

    6
  • Joined

  • Last visited

  1. I fixed it - it was something so simple - I had no product name. As soon as I put a product name in everything worked like a charm.
  2. I am having a problem that I just cannot figure out - please try to stick with me as I try to make sense - this has been three days of working on it. I am hoping some angel will take pity on me and weed through this mess and have some advice for me. I feel like I am losing my mind because I truly cannot see what I might be doing wrong. I upload and do everything I should and it says I have 386 products in the store but I see nothing at all - I just get messages saying there are no products to list in this category. Someone offered me this advice, but it is Greek to me - I would appreciate if anyone could explain it to me like I am a three-year-old: I'm not an EasyPopulate expert ... there are others who use this much more than I have. But the problem is most likely that it's not creating all the required relationships in the various product tables. Primarily these: products products_description products_to_categories and maybe products_attributes I even tried putting in only two items and the same thing happens - this is the tab separated file of the two items: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status v_action EOREOR 5758 images/5758.gif Striped mesh underwire bra with buckle trim, adjustable straps and hook & eye closure. Matching garter belt with adjustable garters and hook & eye closure, matching g-string included $34.50 1 Elegant Moments Lingerie Taxable Goods Active EOREOR 6257 images/6257.gif Embroidered mesh skirted garter with satin ribbon lace up front, back closure, and adjustable & detachable garters. Bra top has underwire, a satin tie at the bodice, adjustable straps and a hook & eye back closure. Matching g-string included $34.50 1 Elegant Moments Lingerie Taxable Goods Active EOREOR My includes/configure.php for what it is worth // Define the webserver and path parameters // Main webserver: eg, http://localhost - should not be empty for productive servers define('HTTP_SERVER', 'http://katieroseintimates.com'); // Secure webserver: eg, https://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://df12.dot5hosting.com/~katieros'); // secure webserver for checkout procedure? define('ENABLE_SSL', 'true'); // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes! // * DIR_WS_* = Webserver directories (virtual/URL) // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder) define('DIR_WS_CATALOG', '/zencart/'); define('DIR_WS_HTTPS_CATALOG', '/zencart/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/'); define('DIR_WS_BLOCKS', DIR_WS_INCLUDES . 'blocks/'); define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/'); define('DIR_WS_PHPBB', '/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/ define('DIR_FS_CATALOG', '/home/katieros/public_html/zencart/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/'); define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', ''); define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'katieros_zencart'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'mysql' // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'database'); define('DIR_FS_SQL_CACHE', '/home/katieros/public_html/zencart/cache'); Lastly, my epconfigure.php but I looked and looked and I think it is okay **** Temp directory **** // if you changed your directory structure from stock and do not have /catalog/temp/, then you'll need to change this accordingly. // $tempdir = "temp/"; $tempdir2 = "/temp/"; //**** File Splitting Configuration **** // we attempt to set the timeout limit longer for this script to avoid having to split the files // NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini // uncomment this if you are not on a safe mode server and you are getting timeouts // set_time_limit(330); // if you are splitting files, this will set the maximum number of records to put in each file. // if you set your php.ini to a long time, you can make this number bigger global $maxrecs; $maxrecs = 300; // default, seems to work for most people. Reduce if you hit timeouts //$maxrecs = 4; // for testing //**** Image Defaulting **** global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category; // set them to your own default "We don't have any picture" gif //$default_image_manufacturer = 'no_image_manufacturer.gif'; //$default_image_product = 'no_image_product.gif'; //$default_image_category = 'no_image_category.gif'; // or let them get set to nothing $default_image_manufacturer = ''; $default_image_product = ''; $default_image_category = ''; //**** Status Field Setting **** // Set the v_status field to "Inactive" if you want the status=0 in the system // Set the v_status field to "Delete" if you want to remove the item from the system <- THIS IS NOT WORKING YET! // If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store. global $active, $inactive, $zero_qty_inactive, $deleteit; $active = 'Active'; $inactive = 'Inactive'; $zero_qty_inactive = false; //**** Size of products_model in products table **** // set this to the size of your model number field in the db. We check to make sure all models are no longer than this value. // this prevents the database from getting fubared. Just making this number bigger won't help your database! They must match! global $modelsize; $modelsize = 100; //**** Price includes tax? **** // Set the v_price_with_tax to // 0 if you want the price without the tax included // 1 if you want the price to be defined for import & export including tax. global $price_with_tax; $price_with_tax = false; // **** Quote -> Escape character conversion **** // If you have extensive html in your descriptions and it's getting mangled on upload, turn this off // set to 1 = replace quotes with escape characters // set to 0 = no quote replacement global $replace_quotes; $replace_quotes = false; // **** Field Separator **** // change this if you can't use the default of tabs // Tab is the default, comma and semicolon are commonly supported by various progs // Remember, if your descriptions contain this character, you will confuse EP! global $separator; $separator = "\t"; // tab is default //$separator = ","; // comma //$separator = ";"; // semi-colon //$separator = "~"; // tilde //$separator = "-"; // dash //$separator = "*"; // splat // **** Max Category Levels **** // change this if you need more or fewer categories global $max_categories; $max_categories = 7; // 7 is default // VJ product attributes begin // **** Product Attributes **** // change this to false, if do not want to download product attributes global $products_with_attributes; $products_with_attributes = false; // change this if you want to download selected product options // this might be handy, if you have a lot of product options, and your output file exceeds 256 columns (which is the max. limit MS Excel is able to handle) global $attribute_options_select; //$attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options // VJ product attributes end I did check and register globals are on because I keep seeing that as an issue. Can someone please direct me to what I must be missing? Here is more history for those who care to go on: I followed these directions: 1. Click Easy Populate 2. Put my xls in catalog/temp (permission is 777) 3. Under "create an export file" Drop down menus say "download Select method to save export file/Select fields to download/Select field for sort order. I left them like that and clicked "start file creation" It gave me a tab-delineated file of all of the headers. 4. I opened the above file in Excel and put the date in the respective colums, careful to preserve the headings and keep them in order. (my v_products_model are numbers, although some have an X on the end for Plus sizes, is that an issue?) Every line ends in EOREOR. 5. Saved the file as a "Text (tab delimited)" file from Excel. 6. Placed the file in the temp directory, and then placed the filename in the box under "Upload from Temp dir" and click Insert Into Database. I think I got everything. I have checked Register Globals in Tools-Server Info and they are on. My temp directory is at http://mydomain.com/zencart/temp. I get all of the words telling me that new products were entered. In Admin I see a category called "Lingerie" that says quantity 386 of 386 active and has a green light. When I open the folder it is empty. When I go to the store the sidebox has a Lingerie link that says (386) and when I click it I get "There are no products to list in this category" I added one item manually to the store and exported it. I took that and exported it to get the headers (v_products_model etc) and compiled the data precisely like the one test that was entered manually. Again, everything as above, with correct EOREOR at the end of every line, etc. When done I put the tab-separated txt file in zencart/temp and then went to Admin-Tools-Easy Populate and "import data from file in temp/" or "upload EP file for import" (I have done each a dozen times) and I get all of the words telling me File Uploaded New Product for every product in the list. Then I go to Catalog-Categories/Products and I see the new category created (Lingerie) and under Quantity it says 0 of 386 active and has a green light. I open that and there is nothing inside. I go to the store through my regular domain and there is nothing at all. I have no / or \ or ' or anything in my descriptions. Register globals are on.
  3. OMG - Can you believe I am still messing with this? Almost 24 hours practically straight - one error after another. I am really not this stupid. Now I am actually entering things - I got as far as that but I can't see anything. It tells me on the admin page that I have 2000 products (not true, it just keeps adding every time I try again and do not see anything). It eventually did add my category and says there are 300 something products in the category - but when I look there is only one, the one I entered manually. Can someone please help me? I know - RTFM, read the posts - I have been reading all day, it is 5 a.m. and I have been sitting here nonstop since 10 p.m. otherwise I would just keep trucking, but I need to try to get this accomplished today if I can and my eyes are falling out from reading manuals and posts over and over again, scouring for what I am missing or doing wrong - I beg for your help!!!!!! Kelli
  4. I did it!!! I fixed it good! I found out that the problem was that I was changing the code "live". I took catalog.php out to Front Page and changed it there, uploaded it back to the server and it worked like a charm!! But you guys probably new that - I am a big 'ol newbie so I thought I would post my revelation here for other newbies who come after me. :D
  5. That did not change it - I still have the same error, so I changed it back. I cannot imagine what I am doing wrong. I just did another completely clean install - I changed nothing, left the name osCommerce added nothing to the store - and got the same thing. I am severely frustrated - I have been on this since 9 a.m. I have put easypopulate.php and easypopulate_functions into admin I made a catalog/temp directory and it is 777 My catalog.php is at home / public_html / osCommerce / catalog / admin / includes / boxes / catalog.php This is the code I cut and pasted: '<a href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '" class="menuBoxContentLink">Easy Populate</a><br>'. <?php /* $Id: catalog.php,v 1.21 2003/07/09 01:18:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ ?><!-- catalog //--><TR><TD><?php $heading = array(); $contents = array(); $heading[] = array('text' =>BOX_HEADING_CATALOG, 'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog')); if ($selected_box == 'catalog') { $contents[] = array('text' => '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_CATEGORIES, '', 'NONSSL') . '">' . BOX_CATALOG_CATEGORIES_PRODUCTS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '">Easy Populate</A><BR>'. '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_MANUFACTURERS, '', 'NONSSL') . '">' . BOX_CATALOG_MANUFACTURERS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_REVIEWS, '', 'NONSSL') . '">' . BOX_CATALOG_REVIEWS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '">' . BOX_CATALOG_SPECIALS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</A>'); } $box = new box; echo $box->menuBox($heading, $contents); ?> </TD></TR><!-- catalog_eof //-->
  6. Let me start off by saying I did RTFM about seven times - I have even re-installed to work from virgin install twice just in case I had messed up somewhere else. I am not a computer genius, but I can usually figure anything out with the manual. I have followed the manual to the letter no less than ten different times and I keep getting this error Parse error: parse error, unexpected '=', expecting ')' in /home/katieros/public_html/store/catalog/admin/includes/boxes/catalog.php on line 16 This is my code from catalog.php <?php /* $Id: catalog.php,v 1.21 2003/07/09 01:18:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright ? 2002 osCommerce Released under the GNU General Public License */ ?><!-- catalog //--><TR><TD><?php $heading = array(); $contents = array(); $heading[] = array('text' =>BOX_HEADING_CATALOG, 'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog')); if ($selected_box == 'catalog') { $contents[] = array('text' => '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_CATEGORIES, '', 'NONSSL') . '">' . BOX_CATALOG_CATEGORIES_PRODUCTS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</A><BR>' .'<A class=menuBoxContentLink href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '">Easy Populate</A><BR>'. '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_MANUFACTURERS, '', 'NONSSL') . '">' . BOX_CATALOG_MANUFACTURERS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_REVIEWS, '', 'NONSSL') . '">' . BOX_CATALOG_REVIEWS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '">' . BOX_CATALOG_SPECIALS . '</A><BR>' . '<A class=menuBoxContentLink href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</A>'); } $box = new box; echo $box->menuBox($heading, $contents); ?> </TD></TR><!-- catalog_eof //-->
×