Jump to content

fantomen

Members
  • Content count

    201
  • Joined

  • Last visited


Reputation Activity

  1. Like
    fantomen reacted to MrPhil in Is there a module for automatic updating stock, products and prices?   
    You could certainly set up a processor on your PC to take the incoming .csv or .txt file and write a new .csv file back out, ready for either manual database import or through Easy Populate. There would be several data configuration files associated with it: markup per category, markup for specific products (override per category), and category per product. You would manually maintain these configuration files with an ordinary editor. When you run the new .csv or .txt file through the processor, it would tell you if any products are missing a category (likely new products) and you would update the category file and rerun the processor. A bonus feature would be to compare the new output to the previous one (saved from the previous time it was run) and only write new and changed entries, in order to run the update faster (dozens or hundreds of updates rather than tens-of-thousands each time).
  2. Like
    fantomen reacted to MrPhil in Is there a module for automatic updating stock, products and prices?   
    Why are you going into Excel (or any other spreadsheet) to add columns and calculate prices? You should be able to read the CSV file with a scripting language such as Perl, and write it back out with new columns with prices and such. How many manual decisions do you need to make for each product? Can it all be reduced to a formula? What about categorizing new products -- is that manually done? You should only have to do it once, for a product or manufacturer, and keep that information around in a file. For routine functions, you should be able to take an incoming CSV or txt file and convert it to something useful to read in either manually or via Easy Populate, without any human intervention.
  3. Like
    fantomen reacted to Smoky Barnable in Is there a module for automatic updating stock, products and prices?   
    @gadlol created the great Alternate Administration System that would do what you need. I'm not sure he is still supporting it but you could ask him.
    https://apps.oscommerce.com/YfzFh&alternative-administration-system-v0-3
     
  4. Like
    fantomen reacted to JcMagpie in Is there a module for automatic updating stock, products and prices?   
    40 000 products! 😊 what ever you use it's going to take time and care to do it properly. Using SQL is going to be the quickest way if you have to update each product individualy with a specific price. Assuming your supplier provides you with a CSV file with all the prices.
    However if you can sort by manufacturer or cat and apply % increase then it's much easier. This add-on lets you do that.
    Quick update BS
  5. Like
    fantomen reacted to MrPhil in Is there a module for automatic updating stock, products and prices?   
    There are some "Easy Populate" modules floating around, that let you update product information from a CSV (text) file. Take a look at that and see if any do the job.
  6. Like
    fantomen reacted to JcMagpie in How can I configure smtp to work in version FROZEN: osCommerce Online Merchant v2.3.4.1 CE ?   
    It's been a long day 😊 maybe I missed somthing? Have you turned on your error reporting? PM me which site and i'll take a look.
  7. Like
    fantomen reacted to JcMagpie in How can I configure smtp to work in version FROZEN: osCommerce Online Merchant v2.3.4.1 CE ?   
    ? you originaly posted them as email.php and e-mail.php I just added the -zi to stop confusion.
  8. Like
    fantomen reacted to JcMagpie in How can I configure smtp to work in version FROZEN: osCommerce Online Merchant v2.3.4.1 CE ?   
    When you have had a long day it pays to stop and look again with fresh eye's 😊. Site back up i'll let you sort out the mail.
  9. Like
    fantomen reacted to JcMagpie in How can I configure smtp to work in version FROZEN: osCommerce Online Merchant v2.3.4.1 CE ?   
    You have your old problem of producing bad files again! clean your files and fix errors and it should be ok. You must use a good editor and turn on error checking.

  10. Like
    fantomen reacted to JcMagpie in How can I configure smtp to work in version FROZEN: osCommerce Online Merchant v2.3.4.1 CE ?   
    Try the attached 2 files, do not open them simply rename them and copy them over. They have been sanitised to remove all strange characters, no code has been changed.
     
     
    email-zi.php
    e-mail-zi.php
  11. Like
    fantomen reacted to MrPhil in How to install Paypal to Frozen osCommerce Online Merchant v2.3.4.1 CE   
    777 is NOT correct on many servers. They will give a 500 error because this is a security exposure ("world writable files"). You start with the minimum permissions on any file (typically 644) and add "write" permissions (664, then 666) until you get it working. Very few servers now require PHP files to be marked "executable" (755, 775, 777). This applies to files that PHP needs to write to, and depends on how PHP is configured (especially, what user group it's running under).
    777 was safe to do back in ancient times, when you could trust everyone sharing your Unix computer. You can't anymore, especially on a server shared with hundreds or even thousands of strangers. Giving them "world write" access to your files is asking for trouble. If someone blithely tells you to "chmod 777 your files", they're an idiot. Don't listen to them.
  12. Like
    fantomen reacted to JcMagpie in How to install Paypal to Frozen osCommerce Online Merchant v2.3.4.1 CE   
    This is a very common problem, If you check carfully you will find the permissions are not correct. I would imagin you are using  Filezilla FTP  to make changes? Filezila will not change permisions correctly it has not done this for some time. So you must access the server directly and change permisions on the server. Make sure both directory and files have required permisions.
  13. Like
    fantomen reacted to JcMagpie in How to install Paypal to Frozen osCommerce Online Merchant v2.3.4.1 CE   
    Either follow this
    https://www.paypal.com/uk/smarthelp/article/how-do-i-integrate-express-checkout-with-oscommerce-ts1559
    or go to the documents and go to PayPal
    https://library.oscommerce.com/public/sites/Library/pdf/oscom23-old.pdf
  14. Like
    fantomen reacted to JcMagpie in Support thread for Product info description_tabs CE   
    Please read the reply is gave!
  15. Like
    fantomen reacted to JcMagpie in Support thread for Product info description_tabs CE   
    JcM Product info description_tabs Select
    Have been updated to version 1.3 to make them multilingual.
    I am not going to update any other version of this so if you need multilingual then turn off curent version and uninstall module and the deleat files. Then simply copy over new files , install in admin and setup.
    For those who are using these but have mofified the code! well it's up to you to compare the changes and update if needed.
  16. Like
    fantomen reacted to JcMagpie in Support thread for Product info description_tabs CE   
    lso I think you are a bit confused! osC is not magic! it will not auto create language files 😊 Yes the tabs at the moment are single language only as I made them for my site but all stock data used is stock osC and it's up to you to add the alternative text.
    This is you english page showing Swedish stock text

    This is your Swedish page again showing Sweedish stock text. Ig noring the tabs ( thats all down to me )  I can only assume yo have not added english text in you products in admin? To use osC as muliligual you have to add text in admin for every language you use. Also every time you change a product info you must make that change to all languages. which is a real pain in the butt!
    Hence I recommend using the Google Translate add-on.  https://apps.oscommerce.com/mYuUD&info-box-with-google-translate-bs4

  17. Like
    fantomen reacted to JcMagpie in Support thread for Product info description_tabs CE   
    Not posiable with current tabs. It's on a long list of thngs to do. You will have noticed I have been updating the ones people have asked for so this will join that list and when I have time it will be updated. Or you can do it your self, its not hard it's simple case of adding a language file and moving the defines from the class to the language file. This will mean that you then have to edit a language file in order make changes rather than simplely in the admin module edit. This should only be affecting new content such as tab names and such. All stock content is still mulitlingual!
    Or you can support the CE software and buy Burt's 28days as I belive it has tabs in it.
  18. Like
    fantomen reacted to burt in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    I'm sure you are not the only stupid user who has never explored their own admin area  
  19. Like
    fantomen reacted to JcMagpie in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    I stand corrected it can be edited and it works! 😊 So why all the add-on's for editing these files? Could it be that I'm not the only stupid user that has never used this function?
    A simple edit statment or  button would make things a bit clearer and silly fools like me might actualy be able to use it.
  20. Like
    fantomen reacted to JcMagpie in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    Hans, you can try this one and see if it helps. Please note I do not use it so check first.
    https://apps.oscommerce.com/8h0g3&edit-pages-via-admin-shipping-conditio
  21. Like
    fantomen reacted to JcMagpie in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    Yes but in stock osC define languages is just a list of files! nothinng to edit just a list. You need aditional add-on's to edit in admin. So please post which add-on you are using so others will know what to use.
  22. Like
    fantomen reacted to JcMagpie in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    It's best not to ask too many questions like that on the forum 😊, just accept the software is what it is and use it as best you can.
    You can replace the stock information with one of the add-ons if you like.
  23. Like
    fantomen reacted to JcMagpie in Where may I edit these texts in the bottom of the website? Installed version FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    About us is in
    includes/languages/english/modules/content/footer/cm_footer_text.php
    contact Us
    includes/languages/english/contact_us.php
    shipping abd the rest will be here
    includes/languages/english/shipping.php
  24. Like
  25. Like
    fantomen reacted to burt in Admin-Configuration-My store How to add zones? FROZEN: osCommerce Online Merchant v2.3.4.1 CE   
    You could also have just done it via the Admin, as Sweden only has a few Zones;
    Admin > Locations/Taxes > Zones > {Add New Zone}
    Answer given for future reference of people finding this thread.
×