jwray100 Posted December 9, 2008 Share Posted December 9, 2008 I am unclear on whether or not Easy Populate will support a Master Products store. I have searched the forums, especially this thread and I can't find a definitive answer. The best I could come up with is using the custom field capability available in this version of EP to add in the fields that are added to the product and product description tables by MP. Will this do it? If so can someone give me a complete list of the new fields. If not can someone tell me what to do to use EP with MP? I'm using: OSC v2.2rc2a Master Products v1.2 Easy Populate v2.76g Thanks for the help. Joel Quote Link to comment Share on other sites More sharing options...
rs2k Posted December 9, 2008 Share Posted December 9, 2008 (edited) I am unclear on whether or not Easy Populate will support a Master Products store. I have searched the forums, especially this thread and I can't find a definitive answer. The best I could come up with is using the custom field capability available in this version of EP to add in the fields that are added to the product and product description tables by MP. Will this do it? If so can someone give me a complete list of the new fields. If not can someone tell me what to do to use EP with MP? I'm using: OSC v2.2rc2a Master Products v1.2 Easy Populate v2.76g Thanks for the help. Joel I assume that a Master Product store simply adds fields to the products and products_descriptions tables that don't exist in a vanilla OSC installation. If that's the case then EP will support that. Our products table is highly modified and all I did was add the extra fields to the EP extra fields section. I have not had very good luck with adding product_description fields with large stores, but it seems to work well with small stores. If the Master Products store has other table changes that you want easypopulate to fill then it will not do that unless you make some major modifications. Edited December 9, 2008 by rs2k Quote Link to comment Share on other sites More sharing options...
hmiintl Posted December 9, 2008 Share Posted December 9, 2008 I do not see an easypopulate 2.76-MS2 available. Are you sure it's not something like 2.76g-MS2? I checked again here is the place says // Current EP Version $curver = '2.76-MS2'; /* Do I need to paste some portion of the codes for your review? Thanks Quote Link to comment Share on other sites More sharing options...
jwray100 Posted December 9, 2008 Share Posted December 9, 2008 I assume that a Master Product store simply adds fields to the products and products_descriptions tables that don't exist in a vanilla OSC installation. If that's the case then EP will support that. Our products table is highly modified and all I did was add the extra fields to the EP extra fields section. I have not had very good luck with adding product_description fields with large stores, but it seems to work well with small stores. If the Master Products store has other table changes that you want easypopulate to fill then it will not do that unless you make some major modifications. From looking at the sql that came with MP the only table changes are the addition of 3 fields to the products table. I used this code in the EP extra fields section for that table (easypopulate.php) and had success on the export (easy part). We'll see how it goes on the import when I get a chance. $custom_fields[TABLE_PRODUCTS] = array( 'products_master' => 'MASTER', 'products_master_status' => 'MASTER_STATUS', 'products_listing_status' => 'LISTING_STATUS' ); Thanks for the help. Joel Quote Link to comment Share on other sites More sharing options...
rs2k Posted December 9, 2008 Share Posted December 9, 2008 I checked again here is the place says // Current EP Version $curver = '2.76-MS2'; /* Do I need to paste some portion of the codes for your review? Thanks If you have not made any more modifications to 2.76-MS2 I would recommend installing 2.76g-MS2 by surfalot. The header names are slightly different with 2.76g-MS2, but it supports 7 category levels. It also supports adding extra fields to the products and products_description tables. Quote Link to comment Share on other sites More sharing options...
surfalot Posted December 10, 2008 Share Posted December 10, 2008 it actually supports an unlimited number of category levels, configurable in the settings. Quote Link to comment Share on other sites More sharing options...
glycerine Posted December 11, 2008 Share Posted December 11, 2008 Hi i receive a feed from my supplier and for the image they give me a call function. Is there a way easy populate can use this call function to populate the image? Here are a few examples: http://afc.retail.sprint3.com/package/webS...ageCode=21.2647 http://afc.retail.sprint3.com/package/webS...mageCode=21.819 http://afc.retail.sprint3.com/package/webS...mageCode=21.809 http://afc.retail.sprint3.com/package/webS...ageCode=21.1754 Thanks Quote Link to comment Share on other sites More sharing options...
rs2k Posted December 11, 2008 Share Posted December 11, 2008 Hi i receive a feed from my supplier and for the image they give me a call function. Is there a way easy populate can use this call function to populate the image? Here are a few examples: http://afc.retail.sprint3.com/package/webS...ageCode=21.2647 http://afc.retail.sprint3.com/package/webS...mageCode=21.819 http://afc.retail.sprint3.com/package/webS...mageCode=21.809 http://afc.retail.sprint3.com/package/webS...ageCode=21.1754 Thanks What you really need to do is download all of those images to your server and then put the image locations into the easy populate file. You could have someone create a script to do all of that for you or even modify EP to do it on the fly, but it would take some custom programming to make it work. I did not find any contribution that does what you ask. Quote Link to comment Share on other sites More sharing options...
needs_a_nap Posted December 11, 2008 Share Posted December 11, 2008 Hi, I had this working fine and did a successful upload after populating the sheet, but now when downloading to my computer add more info, my columns are not showing up at all. I'm sure this is something simple, any ideas? (Have opened in both tab and comma, no difference). I've used this before and had no problems, so I'm stumped. Thanks, Violet Quote Link to comment Share on other sites More sharing options...
Guest Posted December 11, 2008 Share Posted December 11, 2008 I am currently using EP I have had very good luck using this contribution, I am looking to add a blank text input box. This is so customers can add custom text to their items. please let me know if this possible Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 11, 2008 Share Posted December 11, 2008 Wrong thread to post in but try searching the contributions for bilder and be prepared to translate the install instructions from German. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
surfalot Posted December 11, 2008 Share Posted December 11, 2008 I had this working fine and did a successful upload after populating the sheet, but now when downloading to my computer add more info, my columns are not showing up at all. I'm sure this is something simple, any ideas? (Have opened in both tab and comma, no difference). I've used this before and had no problems, so I'm stumped. have you opened it in a text editor? As always for any contribution support, it would really be helpful if you gave some details about the version of the contribution you are using and the version of the osCommerce you are using. In my EP contributions there is a detailed explanation in the docs about what items to post when asking for help. Quote Link to comment Share on other sites More sharing options...
needs_a_nap Posted December 11, 2008 Share Posted December 11, 2008 I've opened it in both Open Office 2.2 Calc as well as the latest MS Excel. It was working fine before and I am certainly not blaming the mod, just curious if it's in the way I'm opening the file, or a setting in the spreadsheet program that I'm forgetting.... it was working great when I originally populated it. I have searched both these forums and Google for the missing columns problem. I have tried both setting the 'replace quotes' to true and false. Here are the settings: Settings & Info EP vers: 2.76g-MS2 osCommerce 2.2-MS2 OS: Linux 2.4.22-1.2199.nptl HTTP: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 DB: MySQL 4.1.22-standard PHP: 5.2.5 (Zend: 2.2.0) Temp Directory: /home/lenore2/public_html/cart/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: true Field seperator: comma Excel safe output: true Preserve tab/cr/lf: true Category depth: 7 Enable attributes: false SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false have you opened it in a text editor?As always for any contribution support, it would really be helpful if you gave some details about the version of the contribution you are using and the version of the osCommerce you are using. In my EP contributions there is a detailed explanation in the docs about what items to post when asking for help. Thanks, Violet Quote Link to comment Share on other sites More sharing options...
glycerine Posted December 12, 2008 Share Posted December 12, 2008 What you really need to do is download all of those images to your server and then put the image locations into the easy populate file. You could have someone create a script to do all of that for you or even modify EP to do it on the fly, but it would take some custom programming to make it work. I did not find any contribution that does what you ask. Thanks Ill have to sort something out. Quote Link to comment Share on other sites More sharing options...
surfalot Posted December 12, 2008 Share Posted December 12, 2008 I've opened it in both Open Office 2.2 Calc as well as the latest MS Excel. have you opened it in a text editor? like Notepad or Wordpad (windoz)? Quote Link to comment Share on other sites More sharing options...
needs_a_nap Posted December 12, 2008 Share Posted December 12, 2008 I hadn't, but just tried.. and the first few lines look like this: "v_products_model","v_products_name_1","v_products_description_1","v_products_url_1","v_products_image","v_products_price","v_products_quantity","v_products_weight","v_date_avail","v_date_added","v_categories_image_1","v_categories_name_1_1","v_categories_image_2","v_categories_name_2_1","v_categories_image_3","v_categories_name_3_1","v_categories_image_4","v_categories_name_4_1","v_categories_image_5","v_categories_name_5_1","v_categories_image_6","v_categories_name_6_1","v_categories_image_7","v_categories_name_7_1","v_manufacturers_name","v_tax_class_title","v_status","EOREOR" "JL-062-132","JL-062 - Colour 132","Size: 4-3/8 ", weight: 1/2 oz.",,"JL-062-132.jpg",8,1,0.5,"0000-00-00 00:00:00",08/01/08 12:42 AM,"JL-062-132.jpg","Crank Bait","JL-062-132.jpg","Alpha Diver",,,,,,,,,,,"Strike Pro","Taxable Goods","Active","EOREOR" "JL-062-302","JL-062 - Colour 302","Size: 4-3/8 ", weight: 1/2 oz.",,"JL-062-302.jpg",8,1,0.5,"0000-00-00 00:00:00",08/05/08 10:48 PM,"JL-062-132.jpg","Crank Bait","JL-062-132.jpg","Alpha Diver",,,,,,,,,,,"Strike Pro","Taxable Goods","Active","EOREOR" "JL-062-206","JL-062 - Colour 206","Size: 4-3/8 ", weight: 1/2 oz.",,"JL-062-206.jpg",8,1,0.5,"0000-00-00 00:00:00",08/05/08 10:49 PM,"JL-062-132.jpg","Crank Bait","JL-062-132.jpg","Alpha Diver",,,,,,,,,,,"Strike Pro","Taxable Goods","Active","EOREOR" "JL-062-205","JL-062 - Colour 205","Size: 4-3/8 ", weight: 1/2 oz.",,"JL-062-205.jpg",8,1,0.5,"0000-00-00 00:00:00",08/05/08 10:49 PM,"JL-062-132.jpg","Crank Bait","JL-062-132.jpg","Alpha Diver",,,,,,,,,,,"Strike Pro","Taxable Goods","Active","EOREOR" have you opened it in a text editor? like Notepad or Wordpad (windoz)? Quote Link to comment Share on other sites More sharing options...
surfalot Posted December 12, 2008 Share Posted December 12, 2008 I hadn't, but just tried.. and the first few lines look like this: On the surface it looks good to me. Maybe I don't understand what "but now when downloading to my computer add more info, my columns are not showing up at all" means. Quote Link to comment Share on other sites More sharing options...
glycerine Posted December 16, 2008 Share Posted December 16, 2008 Hi im just wondering if anyone has modified there code to delete all the products in the catalog then run EP? So what i would like is the user would select there file to upload then click 'insert into db' and it would run a quick query that deletes all the products in the catalog. I have made a custom field that is either 1 or 0, so if custom field = 0 then delete from db else do nothing, then run EP upload. Mainly i would just like to know where to put this in the easypopulate.php file? I can probably do the coding myself but anyone has any better ideas help is much appreciated. Thanks Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 16, 2008 Share Posted December 16, 2008 One of my contributions/add-ons clears down products file or clears it down ready ready for production after testing. Enjoy Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
surfalot Posted December 16, 2008 Share Posted December 16, 2008 Mainly i would just like to know where to put this in the easypopulate.php file? I can probably do the coding myself but anyone has any better ideas help is much appreciated. there is a comment that looks like this: //******************************* //******************************* // UPLOAD AND INSERT FILE //******************************* //******************************* place your code after the IF statement that follows. Quote Link to comment Share on other sites More sharing options...
glycerine Posted December 17, 2008 Share Posted December 17, 2008 Thanks surfalot. Got it all working :D Quote Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2008 Share Posted December 17, 2008 I have installed the most recent version of OSC and Easy Populate and Products Attributes. I have also installed Actual Attributes Price v1.5. Everything appears to be working as intended but I want to allow customers to choose a case or half a case of product, see and receive a volume price. When I use EP to populate the database it adds the price of the attribute to the product price. It inserts the + sign and adds the 2 prices together. I want to show both prices but charge only the attribute price. This does not happen when I use the products attributes interface as I have removed the column that permits the use of the + or - . I can use this interface to remove the plus signs created by EP and get the correct prices to display etc. but I have more than 6000 products with at least one attribute each. Does anyone know how I can stop the + from being inserted in EP without losing the attribute information in the process? Quote Link to comment Share on other sites More sharing options...
surfalot Posted December 17, 2008 Share Posted December 17, 2008 (edited) I don't think you tried searching before posting. ;) Put: Actual Attributes Price into the search field at the lower left of this page. Scroll to the bottom. the line numbers may have changed, but the code didn't. So it should be easy enough to search for. Let me know if you can't find it. Edited December 17, 2008 by surfalot Quote Link to comment Share on other sites More sharing options...
textbook Posted December 23, 2008 Share Posted December 23, 2008 Hey everyone. I love the contribution. I just have one question. Currently, the products in my store do not have a model number assigned to them. Is there any quick way that I can assign them a model number without having to manually edit each item? Thanks a lot. Quote Link to comment Share on other sites More sharing options...
surfalot Posted December 23, 2008 Share Posted December 23, 2008 Hey everyone. I love the contribution. I just have one question. Currently, the products in my store do not have a model number assigned to them. Is there any quick way that I can assign them a model number without having to manually edit each item? Thanks a lot. (ALWAYS BACKUP BEFORE USING) (ALWAYS THOROUGHLY VERIFY AFTER THAT EVERYTHING WENT WELL) you can probably do it a couple ways. 1) export, then use Excel to add a number sequence down the model column. Then clear the products tables in the db and then re-import. 2) add products_id to the configuration item that allows you to add fields to the products table (see the docs, or the top of the easypopulate.php file). Export, then change the products_id column header to the products model header. Delete the empty model number column. Then clear the products tables in the db and then re-import. Method 2 will result in the model numbers matching the current products_id in the table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.