Jump to content

AllTheAbove

Members
  • Content count

    221
  • Joined

  • Last visited

Everything posted by AllTheAbove

  1. AllTheAbove

    Scrolling Marque

    Here is what the instructions say 1. Use phpMyAdmin or the command line mySQL tool to run the commands in install.sql 2. In catalog/includes/header.php find this text: <?php if (isset($HTTP_GET_VARS['error_message']) && tep_not_null($HTTP_GET_VARS['error_message'])) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="headerError"> <td class="headerError"><?php echo htmlspecialchars(urldecode($HTTP_GET_VARS['error_message'])); ?></td> </tr> </table> <?php } Then add: if (SCROLL_MARQUEE == 'true') { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="headerError"> <td class="headerError"><marquee scrollamount=5><?php echo TEXT_TO_DISPLAY; ?></marquee></td> </tr> </table> <?php } ?> 3. That's it. You may want to change the class of the scrolling marquee. Enjoy! Ok.. So I located the text in said file and added the code. No Marquee. I don't even see where I should add the text. There was no other file. When I unzipped the file, it shows an install.sql but as an empty directory. Any help? Thanks Lori
  2. AllTheAbove

    Shipping Contrib First Item X then Y

    Well, apparently OsC still wants a weight put in even if it is not being used to determine shipping cost.
  3. Ok, something isn't working here. It is not showing a shipping charge. I do not have any other shipping method installed. I have amounts in for first item and an amount in for each additional item. Where I am confused is where it says zone. Does this mean I have to specify a zone? All it gives me as options are NONE and my state. We received our first real order and it didn't charge shipping. When I dsid a test order a month ago, it charged me for shipping. I have not changed any code, only added new products. Any help would be appreciated. Lori
  4. 90% of my product is set-up as flat rate first item + additional each item after. Thing is, I have some items that are oversize or overweight and therefore require addition fees for shipping. Do I need a seperate shipping module? If so, how would I implement it so that there isn't a choice at checkout, there is merely the charge. Preferably, it would show the line item at check-out like standard shipping then additional shipping for overweight/oversized item or something similar. That way the customer knows the additional shipping is/will be for only the heavy/large item. I had considered adding the "Call for Pricing" module, however, most people want to conclude the transaction when they are on the site, not wait for a response then provide credit card info by other means. Thanks in advance for your help Lori
  5. AllTheAbove

    Two shipping modules, not standard

    Ok.. I've been trying to get this to work. I edited the database so that products_extra_ship is in the products table. I edited categories.php under admin side and added products_extra_ship anywhere I saw products_weight. I really have no clue how to add an extra field. When I go to edit the product, there is no extra_ship field. My categories.php is almost 2400 lines so I am remiss to post it here. I would happily send it to someone to look at if they have the desire to help me figure this out. I am not asking someone else to do the work, just looking for direction. I have not attempted to edit the shipping module yet as I just want the field to show up in admin first. One more question. Will I be able to use EP to populate that field? Thanks for anyone who is trying to help Lori
  6. AllTheAbove

    Two shipping modules, not standard

    On the products table, do I make the column type enum? I was thinking that the column would default null, meaning it is a "normal" product. This is how I defined the table : name extra_ship; type enum; length/values 'Y'; collation and attributes are empty; Null; default and extra are empty. Is this anywhere near correct? Then I can add the field to categories.php to recognize that if a "Y" is typed there, to call the shipping module file. Then, in the shipping module file, I can define that "Y" in field oversize = $30 or whichever price is determined. Am I on the right track? Thanks for the help! Lori
  7. Hi everyone! I have a really simple question. I wanted to create seperate spreadsheets according to product as most of my products have numerous attributes. I wanted to do this for a few reasons, the most important being easy of editing and uploading. Before doing so, I needed to ask a simple and probably stupid question. In the header row, you know where you say v_attribute_values_id_1_1 do I have to continue sequentially in a new spreadsheet? Sheesh I don't know if I explained that right.. I know the value down the column cannot be reused as it effects other products. Lets see if I can be a little more clear. toys.txt has 50 products with a grand total of 45 seperate attributes so that v_attribute_values_id_1_1 actually ends at v_attribute_values_id_1_45 Now I want to start clothes.txt does v_attribute_values_id_1_1 have to be v_attribute_values_id_1_46 or can it be 1 all over again. Just to be clear, whether it can be v_attribute_values_id_1_1 or not, I know the actual number that I would put on the product would be 46 as 1 - 45 are assigned already. I hope I explained this clearly enough and I hope someone can answer my question. Thanks Lori
  8. AllTheAbove

    Two shipping modules, not standard

    Thanks for the explanation. I will back-up my database and the files then try to do the changes and see where it takes me. Lori
  9. AllTheAbove

    Two shipping modules, not standard

    Sorry, no, it doesn't make sense. What products table? Is that part of phpmyadmin or would that be like the "taxable goods" thing?
  10. Mibble, I added Hunchback, Igor and Nunka by hand.. When I downloaded the file, it was all screwy like this one. I had tried asking a while back about it. I figured I would fix the spreadsheet by hand and add a new product with new options, upload then see if it triggered anything. As I stated, it looks fine in admin and on the webpage, however downloading the "complete" spreadsheet turns out looking like the above. Lori
  11. Here I am again.. Same question different day.. Hoping to get an answer soon.. Here is the situation.. I downloaded the EP file. I added a few fake products. I uploaded the EP file. I manually added some attributes and options so I could see how they are set-up in the spreadsheet. I checked to make sure all looked fine on the website and it did. I then downloaded the new EP file. I opened the new EP file in Excel as tab-delim. Lo-and-behold it was all screwy. Here is the spreadsheet - descriptions have been truncated to save space. v_products_model v_products_image v_products_image_med v_products_image_lrg v_products_name_1 v_products_description_1 v_products_head_title_tag_1 v_products_head_desc_tag_1 v_products_head_keywords_tag_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_values_id_2_1 v_attribute_values_price_2_1 v_attribute_values_name_2_1_1 v_attribute_values_id_2_2 v_attribute_values_price_2_2 v_attribute_values_name_2_2_1 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_values_id_3_1 v_attribute_values_price_3_1 v_attribute_values_name_3_1_1 v_attribute_values_id_3_2 v_attribute_values_price_3_2 v_attribute_values_name_3_2_1 v_attribute_options_id_4 v_attribute_options_name_4_1 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_tax_class_title v_status EOREOR ABC123 Igor Big ugly doll 10 0 0000-00-00 00:00:00 9/16/2005 10:58 10 213 Color 1 0 Original 2 0 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version Children Toys Dolls Taxable Goods Active EOREOR ABC456 Hunchback Doll with huge back problem 10 0 0000-00-00 00:00:00 9/16/2005 10:58 10 213 Color 1 0 Original 2 0 Addition 216 Black Boots 3 2 Subtraction 5 0 None 217 Frilly Purse 4 Multiplication 6 None 218 Version Children Toys Dolls Taxable Goods Active EOREOR ZED_401 Nunka A figment of your imagination 100 0 9/16/2005 10:34 9/16/2005 10:58 10 213 Color 1 0 Original 2 0 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 5 Multiplication 6 0 None 218 Version Clothing Children Dress-up Taxable Goods Active EOREOR ARIS_SPOT aristoplay/tn_spotdot_multi.jpg aristoplay/spotdot_regular.jpg aristoplay/spotdot_large.jpg Spot The Dots game description multiplication addition subtraction game math fun solitaire competitive competition aristoplay talicor 12 0 9/22/2005 10:14 100 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version Talicor Games Board Children Educational Taxable Goods Active EOREOR PC-SWAT3 sierra/swat_3.gif SWAT 3: Close Quarters Battle really long description 79.99 7 5/27/2005 21:07 9/16/2005 10:58 16 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version Sierra Software Simulation Taxable Goods Active EOREOR PC-UNTM gt_interactive/unreal_tournament.gif Unreal Tournament another long description 89.99 0 5/27/2005 21:07 9/16/2005 10:58 89 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version GT Interactive Software Action Taxable Goods Active EOREOR PC-TWOF gt_interactive/wheel_of_time.gif The Wheel Of Time sheesh can you get any longer 99.99 10 5/27/2005 21:07 9/16/2005 10:58 16 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version GT Interactive Software Strategy Taxable Goods Active EOREOR PC-DISC gt_interactive/disciples.gif Disciples: Sacred Lands enough with the long descriptions 90 8 5/27/2005 21:07 9/16/2005 10:58 16 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version GT Interactive Software Strategy Taxable Goods Active EOREOR GIFT_25 giftcert-25-sm.gif $25 Gift Certificate Buy a Gift Certificate for your friends or family $25 Gift Certificate $25 Gift Certificate gift, certificate, store 25 0 5/27/2005 21:07 9/16/2005 10:58 97 213 Color 1 Original 2 Addition 216 Black Boots 3 Subtraction 5 None 217 Frilly Purse 4 Multiplication 6 None 218 Version Gift Vouchers Gift Certificate --none-- Active EOREOR Now, allow me to direct your attention to the attributes and options. Hunchback and Igor are supposed to come with the color options of red and green. Notice how, instead, there are other things there. Huncback is supposed to come with the option to add black boots. Again, missing. Nunka is supposed to come in red or green and have the option to add a frilly purse. Spot the Dots comes in addition, subtraction, multiplication and original. The software should not have any attributes or add-on options, yet it does. It looks just fine on the website. It looks fine on my hand created spreadsheet. It looks fine in admin. It is completely messed up upon download of EP spreadsheet. Can someone please explain what is going on here and a possible solution????? Thanks! Lori
  12. Ok, so I went in and manually added the attributes and values to the corresponding products. When I downloaded the sample file, it had put the attributes on all products. See below for what I mean. v_products_model v_products_image v_products_image_sm_1 v_products_image_xl_1 v_products_name_1 v_products_description_1 v_products_url_1 v_products_head_title_tag_1 v_products_head_desc_tag_1 v_products_head_keywords_tag_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_values_id_2_1 v_attribute_values_price_2_1 v_attribute_values_name_2_1_1 v_attribute_values_id_2_2 v_attribute_values_price_2_2 v_attribute_values_name_2_2_1 v_attribute_options_id_3 v_attribute_options_name_3_1 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR ABC123 Igor Big ugly doll 10 0 9/13/2005 14:26 9/14/2005 13:13 10 5 Return Address 10 13 213 Color 1 0 Red 2 0 Green 216 Accessories Children Toys Dolls --none-- Active EOREOR ABC456 Hunchback Doll with huge back problem 10 0 9/13/2005 14:26 9/14/2005 13:13 10 5 Return Address 10 13 213 Color 1 0 Red 2 0 Green 216 Accessories Children Toys Dolls --none-- Active EOREOR PC-SWAT3 sierra/swat_3.gif SWAT 3: Close Quarters Battle <b>Windows 95/98</b><br><br>211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and "When needed" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor! www.swat3.com 79.99 7 5/27/2005 21:07 5/27/2005 21:07 16 5 Return Address 10 13 213 Color 1 Red 2 Green 216 Accessories Sierra Software Simulation Taxable Goods Active EOREOR PC-UNTM gt_interactive/unreal_tournament.gif Unreal Tournament From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.<BR><BR>This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It's a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of 'bots' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master. www.unrealtournament.net 89.99 0 5/27/2005 21:07 89 5 Return Address 10 13 213 Color 1 Red 2 Green 216 Accessories GT Interactive Software Action Taxable Goods Active EOREOR PC-TWOF gt_interactive/wheel_of_time.gif The Wheel Of Time The world in which The Wheel of Time takes place is lifted directly out of Jordan's pages; it's huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you're playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter'angreal, Portal Stones, and the Ways. However you move around, though, you'll quickly discover that means of locomotion can easily become the least of the your worries...<br><br>During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time's main characters. Some of these places are ripped directly from the pages of Jordan's books, made flesh with Legend's unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you'll have this year. www.wheeloftime.com 99.99 10 5/27/2005 21:07 5/27/2005 21:07 16 5 Return Address 10 13 213 Color 1 Red 2 Green 216 Accessories GT Interactive Software Strategy Taxable Goods Active EOREOR PC-DISC gt_interactive/disciples.gif Disciples: Sacred Lands A new age is dawning...<br><br>Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.<br><br>The day of reckoning has come... and only the chosen will survive. 90 8 5/27/2005 21:07 5/27/2005 21:07 16 5 Return Address 10 13 213 Color 1 Red 2 Green 216 Accessories GT Interactive Software Strategy Taxable Goods Active EOREOR GIFT_25 giftcert-25-sm.gif gv_25.gif gv_25.gif $25 Gift Certificate Buy a Gift Certificate for your friends or family $25 Gift Certificate $25 Gift Certificate gift, certificate, store 25 0 5/27/2005 21:07 97 5 Return Address 10 13 213 Color 1 Red 2 Green 216 Accessories Gift Vouchers Gift Certificate --none-- Active EOREOR As you can see, it has put "return address" as an option. No clue how that happened. It also has attached the color options to the preexisting video games. Lastly, it has completely left out the option to add boots to hunchback , yet it has added accessories to everything. I was hoping that manually editing the catalog then downloading it would tell me how I need to set this up, but at it has done is cause me more confusion. Thanks for looking. Lori
  13. AllTheAbove

    Individual Product Shipping Prices

    I think you might need Multi-vendor shipping or Multi-geo table shipping. I don't use either one, but when I was looking for a shipping module both of those came up as very versatile, but more options than I really needed. http://www.oscommerce.com/community/contributions,2571 Multi Geo http://www.oscommerce.com/community/contributions,2906 Multi vendor- This one says its in beta but from what I have been reading in the support thread, its good to go. Lori
  14. I asked yesterday for some help with getting this to work right. Anyone who has used attributes successfully can help me. I tried changing how I put it in the spreadsheet but that didn't work either. Here is what I am trying to upload: v_products_model v_products_name_1 v_products_description_1 v_products_price v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_1_2 v_categories_name_1 v_categories_name_2 v_categories_name_3 v_xsell_product_id v_tax_class_title v_status EOREOR ABC123 Igor Big ugly doll 10 10 Color Green Color Blue Color Red Children Toys Dolls ABC456 EOREOR ABC456 Hunchback Doll with huge back problem 10 10 Color Green Color Blue Color Red Accessories 2 Black Boots Children Toys Dolls ABC123 EOREOR The output is merely Igor and Hunchback with no options for color or for boots in Hunchback's case. Thanks for any help Lori
  15. Ok.. still trying to get the whole attribute/options/xsell thing figured out. I am uploading a couple fake products, Igor and Hunchback. They both come in Green, Red and Blue. Hunchback can come with Black, White or Yellow Boots for an additional 2.00 I have put in v_xsell_product_id in which I put the other one's model. When I uploaded, Igor showed only as available in green with no option to choose another color. Hunchback was available only in green with only black boots available. Neither one was xselling the other. I am pasting the few lines I am uploading, hopefully it is readable. v_products_model v_products_name_1 v_products_description_1 v_products_price v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_categories_name_1 v_categories_name_2 v_categories_name_3 v_xsell_product_id v_tax_class_title v_status EOREOR ABC123 Igor Big ugly doll 10 10 Color Green Children Toys Dolls ABC456 EOREOR 10 10 Color Blue ABC456 EOREOR 10 10 Color Red ABC456 EOREOR ABC456 Hunchback Doll with huge back problem 10 10 Color Green Accessories 2 Black Boots Children Toys Dolls ABC123 EOREOR 10 10 Color Blue Accessories 2 White Boots ABC123 EOREOR 10 10 Color Red Accessories 2 Yellow Boots ABC123 EOREOR Your help would be greatly appreciated. Oh, yes I have xsell installed and when I do it manually in admin, it works just fine. Thanks Lori
  16. AllTheAbove

    Multi-Stores Multiple Shops Support

    Ok.. I will assume the cart *IS* shared between all stores.. Which store rules the shipping method & costs? If Store A sells bakery items and needs overnight or 2nd day at most Store B ships UPS only Store C gives customer the option of UPS or USPS Store D ships FedEx only Customer bought an item from each store and is ready to checkout. How is the shipping handled? Thanks Lori
  17. AllTheAbove

    Multi_Vendor_Shipping new thread

    You might try Per Item shipping.. I think it is under individual shipping per item or something similar. From what I read on the thread it allows you to have items with individual shipping prices (like the posters) along with items that go regular mail (maybe a CD or t-shirt). Lori
  18. AllTheAbove

    Multi_Vendor_Shipping new thread

    I went to the "test" site to check this out and got an error just putting in the url 1146 - Table 'bcsales_osc1.whos_online' doesn't exist delete from whos_online where time_last_click < '1125418439' [TEP STOP] Has the test site moved or is it just currently being updated? Thanks Lori
  19. Hi.. I'm still looking for an answer for my question above. Just to paraphrase.. When adding attributes and options, how do I get EP to see the same ones as a single option and not multiple. Example.. T-shirts come in S, M, L and in White, Blue, Black. I want it to show each option as a single instance instead of 3 small (one for each color) or 3 white (one for each size). Do I need a different contrib for this? Also, say I have T-shirts that come in colors but I also have candles. I would like the attribute of White to show only once and not twice (once for t-shirts and once for candles). Is this possible? Thanks Lori
  20. AllTheAbove

    Easy Populate

    Products are put in across a row.. So you have model_id;product_name;product_image;image_url;more_fields_here;EOREOR The each row will have its own product
  21. Ok.. I went into phpmyadmin and then into my database area and deleted the options and values tables.. so all those orphaned attributes are gone.. Now.. how do I keep it from doing it again? So if I have 20 products that come in White, Red, Fushia etc I want only one value for white not 20. Same as if they all came in small, med, large.. I want one value/option to represent small, not 20 of them When setting up my spreadsheet, how do I get it to see it as one option? thanks Lori
  22. Any help on the above problem? Thanks Lori
  23. Ok, I found out (sort of) what happened. I loaded a sample file where the products had several atributes and values. How do I make OSC recognize that the attributes are the same. Example from this file.. Notepads.. they come in 5 sizes and each size has 5 colors of paper and 5 colors of ink. There are also options for monogram or a small text field at the top of the note. What happened is that EP created a brand new attribute value and option for each instance. So, instead of there being one blue which applies to all sizes for paper color, there are 25. It created a paper color for everysize and every ink color. It did the same with ink color. My question now is how do I get EP to see that ink color=blue only needs to be an attribute once? BTW, these were all contained in drop down boxes and were duplicated. Example.. When you went to the product to select options it appeared like this product 213456 ink color - dropdown box ink color - dropdown box ink color - dropdown box ink color - dropdown box paper color - dropdown box ink color - dropdown box price There was no place to indicate whether you wanted any sort of text applied. I realize it is most likely a result of how the spreadsheet was created. I am only using it as an example of how to set up my products and did not create it. Oh, and if it makes a difference, but the fields in the spreadsheet were like this v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 The thing is, going down the rows, they were all the same. Like for options_name they all said paper color. I guess I am trying to find out if this is always going to do this. Also, when it uploaded, it applied Paper Color as a return address option for one of the default products that comes with OSC. How do I get it to show Paper Color = White one time instead of several hundred? Ok, I think I have rambled enough.. Hope this made sense! Lori
  24. I have another question.. Whats the difference between v_attributes_options_id and v_attributes_values_id ?
  25. Yes, some of my products have attributes.. just not 185 of them..
×