Jump to content

fantomen

Members
  • Content count

    202
  • 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 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.
  7. 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.
  8. 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
  9. Like
    fantomen reacted to JcMagpie in Support thread for Product info description_tabs CE   
    Please read the reply is gave!
  10. 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.
  11. 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

  12. 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.
  13. Like
    fantomen reacted to JcMagpie in “Google Maps” make it work for you! It’s free and easy.   
    JcM footer Google Map V1.0
    Thank you to @fantomen for reporting the bug in the add-on, a silly mistake by me in naming files which caused a conflict on multilingual sites. This has now been fixed and a updated add-on as been uploaded.
     
  14. Like
    fantomen reacted to ArtcoInc in Regarding the contribution: Edit pages via Admin   
    @fantomen
    I understand the convenence of being able to edit information pages through Admin, and not having to deal with uploading new files anytime you want to change the text in these pages. In fact, I have used one of these type of packages in one of my shops. However, I won't be using one for any future shops, and I will most likely remove it from the existing site. Here's why:
    I find that for the type of shops I run, I want the information of ALL pages to be searchable. If a customer enters a search request for some information that is on one of these pages, they won't find that page using one of these packages. So instead, I am using a search module that allows my customers to search products, categories (where I have a LOT of information), and any standalone page that uses a language file to display that page's content. So, if my customer searches for "entertaining" or "adult only", they can find those expressions, even if they are not in a product's name (the stock search function is limited to just the product name).
    Also, pay attention to how these packages work if you intend to have more than one language on your shop.
    HTH
    Malcolm
  15. Like
    fantomen reacted to Smoky Barnable in Regarding the contribution: Edit pages via Admin   
    I love the Edit pages via Admin addon by Fimble and use it all the time in my frozen shop. It's very easy to change the text, font color, font size etc. from the admin using the CKEditor. It's easy to add this to your index page too so you can edit the main text easily from your admin. I use it to quickly add latest news or comments from the admin, quickly update shipping or privacy policy. As others have mentioned, it's just a matter of defining filenames and database tables.
  16. Like
    fantomen reacted to Smoky Barnable in Regarding the contribution: Edit pages via Admin   
    Yes, I followed these instructions but I didn't need steps 15-17. You can use the compatibility add-on or hard-code the variables that aren't defined in frozen. I just included these files in includes/application_top.php
    // include the list of project database tables require('includes/database_tables.php'); // include the list of project filenames require('includes/filenames.php');  
  17. Like
    fantomen reacted to Jack_mcs in Regarding the contribution: Edit pages via Admin   
    It is possible but not the best way to do it. The idea is to replace those files with a dynamic page. See the Information box in the footer of my site. Almost all of the links in it have been created with the Information Pages addon. If you want to keep the hard-files, or have others you want to use, there is a one-line change you can make to those files to control the text in admin. So, technically, if you used that method it would be the same as it is with the addon you mentioned, though that would be extra work for no good reason,.
  18. Like
    fantomen reacted to ArtcoInc in Regarding the contribution: Edit pages via Admin   
    @fantomen
    As @Jack_mcs has pointed out, this add-on was written for an earlier version of osCommerce. You can adapt it to 'Frozen', but it will require a few edits to the add-on code. While I have not downloaded this add-on to examine the code, here are some of the changes you will have to make:
    Some time ago, Burt got rid of the filenames.php and database_tables.php files. Instead, all calls to a file, directory, or database table are now hard-coded (in both the core code, and in any add-on). You can address this in one of two ways:
    1) Install the compatibility add-on
    http://addons.oscommerce.com/info/9506
     
    2) Hard-code the paths into this add-on. This is not difficult to do ... probably the biggest mistake people make is that they miss one (or more) of these needed edits.
    (like I said, I have not downloaded this add-on, so the following example are just that ... examples. You will have to find the applicable code in your add-on)
    Search through the code, and wherever you find something like this:
    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT); notice the names in capitol letters. You will have to change both of these:
    a ) Where it says DIR_WS_LANGUAGES , this was a definition in the configuration file telling where the LANGUAGES directory is. You will need to change this to the actual directory name, which in this case is languages/.
    b ) Where it says FILENAME_CREATE_ACCOUNT, this is where the filenames.php file defines what the CREATE_ACCOUNT file is called. You will need to change this to the actual file name, which in this case, is create_account.php.
    Changing both of these will result is something like this:
    require('languages/' . $language . '/create_account.php'); (like I said, this is just an example, and not some actual code from this add-on)
    So, just go through all of the code in the add-on, and search for anything with all capitol letters. If it starts with DIR_ , it is a directory name. If it starts with FILENAME_ , it is a file name.
    c ) In any database call, you will see something like this:
    $query = tep_db_query("select a.customers_id, a.customers_firstname, a.customers_lastname, b.entry_company, b.entry_city, c.zone_code from " . TABLE_CUSTOMERS . " AS a, " . TABLE_ADDRESS_BOOK . " AS b LEFT JOIN " . TABLE_ZONES . " as c ON (b.entry_zone_id = c.zone_id) WHERE a.customers_default_address_id = b.address_book_id ORDER BY entry_company,customers_lastname"); let me reformat that to be easier to read ...
    $query = tep_db_query("select a.customers_id, a.customers_firstname, a.customers_lastname, b.entry_company, b.entry_city, c.zone_code from " . TABLE_CUSTOMERS . " AS a, " . TABLE_ADDRESS_BOOK . " AS b LEFT JOIN " . TABLE_ZONES . " AS c ON (b.entry_zone_id = c.zone_id) WHERE a.customers_default_address_id = b.address_book_id ORDER BY entry_company, customers_lastname"); There are three entries that begin with TABLE_ . These are the database table names, and will now have to be hard coded. In this case, TABLE_CUSTOMERS refers to the customers table, TABLE_ADDRESS_BOOK refers to the address_book table, and TABLE_ZONES refers to the zones table. So, the edited command would now be:
    $query = tep_db_query("select a.customers_id, a.customers_firstname, a.customers_lastname, b.entry_company, b.entry_city, c.zone_code from customers AS a, address_book AS b LEFT JOIN zones AS c ON (b.entry_zone_id = c.zone_id) WHERE a.customers_default_address_id = b.address_book_id ORDER BY entry_company, customers_lastname"); (like I said, this is just an example, and not some actual code from this add-on)
     
    d ) One other coding style has changed, preparing osCommerce for newer versions of PHP. In the code, you may find something like this:
     
    $email_address = tep_db_prepare_input($HTTP_GET_VARS['email_address']); if (!@ $HTTP_POST_VARS['action']) { Whenever you see a $HTTP_POST_VARS or a $HTTP_GET_VARS, these will need to be changed to $_POST or $_GET, respectively. Please note that these changes are to make the code compatible with newer versions of PHP, and is not an indication of the add-on, or of osCommerce.
    If you can apply all of these changes, and get this add-on to work properly, you could then give back to the community by uploading your updated code to the add-on repository.
    If you find that this it too much for you to do, you can always post in the commercial portion of the forum to hire someone to do this for you. If you do do this, please pay it forward by uploading the revised code to the repository.
    Or, as @Jack_mcs has suggested, you could try another add-on.
    HTH
    M
     
  19. Like
    fantomen reacted to Jack_mcs in Regarding the contribution: Edit pages via Admin   
    @fantomenIt won't work in your shop because it needs the filenames file which does not exist. I suggest you try Information Pages instead. It is CE compatible and an easier install.
  20. Like
    fantomen reacted to ArtcoInc in Regarding the contribution: Edit pages via Admin   
    @fantomen
    Like the instructions said, in the default installation of osCommerce, the shop is loaded in the /catalog sub-directory. This is the 'root' of the shop, NOT the domain. This is typically done so that you may have other functions (ie: a blog, etc) under your domain. For example:
    <your domain> <your domain>/catalog/ <your domain>/<your blog directory> <your domain>/<any other function or directory you want> If you have installed osCommerce in the root directory of your site, just ignore the part of the instructions where it includes the directory path "catalog/", and do the changes in the root directory of your site.
    HTH
    M
  21. Like
    fantomen got a reaction from Antonio Garcia in What is latest responsive version of oscommerce that is still updated?   
    Thank you for your quick reply.
    You sent me a picture link and in the top of this  I can read this:

    "Example site of (more or less) 2.3.4 with Bootstrap 3.
    http://template.me.uk/234bs3/index.php

    Please point out any areas that you feel need attention.  Thanks

    Gold Download:
    https://github.com/gburton/osCommerce-234-bootstrap/archive/v2.3.4-GOLD.zip

    EDGE:  Gold + Extra Commits such as bugfixes:
    https://github.com/gburton/osCommerce-234-bootstrap/archive/master.zip "

    And you also sent me this in text:
    Frozen here https://github.com/gburton/Responsive-osCommerce/archive/2341-Frozen.zip
    Edge here https://github.com/gburton/Responsive-osCommerce/archive/master.zip

    Which of the above 4 versions is the latest version that works and is still in development?
    What version should I use to install a functional respnsive webshop?
     
×