Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

gadlol

Members
  • Posts

    241
  • Joined

  • Last visited

  • Days Won

    13

Posts posted by gadlol

  1. multilingual support, very nice! and the window is wider then in v 0.1. don't tell me you speak german too.

     

    Yes multilingual support and the window is wider (it covers 90% of your screen).

     

    No I dont speak German. I just added that language to make some tests.

     

    ---------------------------------------------------------------------------------------------

     

    Some latest news about A.A.S. development:

     

    I have implemented it in a such way, that you can now add links to directly open the A.A.S. plugins.

     

    For example you may want to have a link to open directly the Calendar plugin.

     

    So the link will be catalog/admin/aas.php#calendar

    For Specials Manager catalog/admin/aas.php#specials_manager

     

    You dont have to worry about that links.

    I have implemented those in a file, which you will put it in the catalog/admin/includes/boxes/ and they will be automatically created as a new menu in the column left accordion menu.

     

    Have a look at the screenshot to see for your self:

     

    post-284725-0-82332300-1382390728_thumb.jpg

     

    Everything is almost ready, what's left, is to make a video to explain - show the A.A.S. in action.

     

    Thank you for staying tuned.

  2. Hi John,

     

    Your approach for AAS is definitely a winner and I am looking forward to the new version.

     

    As for your question for requests it would be great to see Product Specifications in AAS ... You could start of with http://addons.oscommerce.com/info/8096

     

    To clarify I describe the (my) definition of an Attribute ... I would say a Product Attribute would be a a different SKU since the attribute "changes" the product (for example Attribute Memory changes the price of the product and probably it is a different box with a different EAN-code - hence different SKU). See demo store http://demo.oscommerce.com/product_info.php?cPath=1_4&products_id=1

     

    A Product Specification I would describe as ... (a set of) common product specifications you would like to have displayed in a table for example for comparison. So for the same product you probabaly have the followoing specifications:

    • BRAND - Matrox
    • EAN - 4949812333111
    • MULTI MONITOR - Yes
    • WEIGHT - 300 grams

    Note that Specifications do not change the product SKU.

     

    I did some developing for specifications long time ago to make it work with Ajax (based on the Add-On) and it is kind of copy-paste your attributes code...

     

    How could it work? An adminstrator would make a standard Specifactions Set - Assign Specifactions Set to (a set of) products or category - Copy a set for the next category - make some changes to Specification Name - Add a new Specification .... etc.etc. Probably adminstrator would also want to set different values for using the specification in Filtering (yes-no) - using it in Comparison (yes-no).

     

    It would be great to see Specifications is AAS! And off course I will be happy to make a donation :thumbsup: :)

     

    Regards!

     

    Hello Arjan.

     

    I will create Product Specifications for AAS later (as a plugin for AAS) because it needs lots of coding and testing so everything will work fine.

     

    Have a look at the way you can edit, via ajax always, a product's description in the upcoming 0.2 version:

     

    post-284725-0-64512200-1382122025_thumb.png

  3. Hi John

     

    Thank you for this fantastic Add-On!

    I installed it local for testing and i'm getting following message if i activate the Field Tax Class/Rate from the menu on the right side.

     

    Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\Users\my name\Music\xampp\htdocs\testshop\admin\tbl.php on line 189

     

    and no Tax Class/Rate is showing in the drop-down menu. did i install something wrong? Or is this a known bug that will be fixed with the coming update 0.2?

     

     

     

     

     

    will this be added also in the 0.2 version?

     

    Thanks again and greetings from far east.

    Lambros

     

    Hello Lambro (Lambros is a Greek name, are you Greek?).

     

    Yes I know the existence of that bug.

    It has already been fixed in version 0.2. (that bug happened because I forgot to change some mysql to tep_db_query)

    So, wherever you see mysql_query replace with tep_db_query and mysql_num_rows with tep_db_num_rows and mysql_fetch_array with tep_db_fetch_array

     

    But I strongly recommend waiting for the new version. Which is far far far better....

     

    Yes Gross price in version 0.2 is editable. (You can edit single product's gross price or multiple products' gross prices)

  4. LATEST NEWS ABOUT THE AAS:

     

    The Alternative Administration System: Categories/Products is renamed to Alternative Administration System.

     

    Almost all the features of version 0.1 have been improved.

     

    Product's editing description method has been changed dramatically. Now you can edit in other languages easily by clicking on the languages flag icon (for example: imagine editing a product in 4 languages, you make the changes in the text for every language and then you press a button to preview the changes and then another button to submit all the changes).

     

    Gross price is also editable as requested.

    The discount edit product prices drop down menu now includes the "=" for pricing selected products at the same price as requested

     

    New things:

    1. ajax Temp list where you can "save" products from different categories so you can use other functionalities to them such as copy attributes
       
    2. ajax Copy, Move or Link products
       
    3. ajax copy or delete attributes from a product to selected products or to products the are under a category and/or subcategories
       
    4. ajax product's changes file import (export products data in a file and edit them using your favorite editor then upload and apply changes)
       
    5. ajax Attributes Manager.
       
    6. ajax Online Users Viewer (via charts => highCharts), + online users per country.
       
    7. ajax Calendar, keeping - adding events, notes
       
    8. ajax Worldwide Clocks
       
    9. ajax Specials Manager, yes you read it right. Now you can easily edit-add specials products!
       
    10. ajax All Edit method. You can edit all values easily without clicking in every cell.

    The whole code has been "dramatically" improved.

    I am coding AAS in such a way so you can easily install it, making as less as possible changes in the osc core files.

     

    Please wait a few more days for the next release!

     

    Note: I dont own a website running oscommerce cms, so I dont know exactly what your needs are.

     

    So if you need something special to develop and to be included in the AAS reply here.

  5. Hi John,

    Thanks for spending the time to create such a useful add on.

    I am trialling it on a test website. I had no problems installing it on osc2.3.3.4

    I found I needed to make the following minor alterations:

    Change 1

    The ax icon was missing due to missing .png in

    tbl.php

    Line 469

    -<div id="discountbutton" class="koumpakia" data-title="<?php echo TBL_BUTTON_TOOLTIP_DISCOUNT; ?>" style="display:none;" ><?php echo tep_image(DIR_WS_ADMIN . 'ext/tbl/images/glyphicons_313_ax','' ); ?></div>

    Change to

    -<div id="discountbutton" class="koumpakia" data-title="<?php echo TBL_BUTTON_TOOLTIP_DISCOUNT; ?>" style="display:none;" ><?php echo tep_image(DIR_WS_ADMIN . 'ext/tbl/images/glyphicons_313_ax.png','' ); ?></div>

     

    Change 2

    In the installation PDF

     

    STEP 6 (OPTIONAL):

    Insert a link to the left column.

    From catalog/admin/includes/boxes/catalog.php find

    array(

    'code' => FILENAME_CATEGORIES,

    'title' => BOX_CATALOG_CATEGORIES_PRODUCTS,

    'link' => tep_href_link(FILENAME_CATEGORIES)

    ),

    and add below

    array(

    'code' => FILENAME_TABLEDATA,

    'title' => TBL_LINK_TITLE,

    'link' => tep_href_link(FILENAME_TABLEDATA)

     

    Change to

    and add below

    array(

    'code' => FILENAME_TABLEDATA,

    'title' => TBL_LINK_TITLE,

    'link' => tep_href_link(FILENAME_TBL)

     

    Finally, in the discount edit product prices drop down menu would it be to include an “= “ for pricing selected items at the same price

    We think this can make our admin tasks so much easier.

    Thanks again for a great app.

    Regards

    Tom

     

    Hello Tom.

     

    Thank you a lot!

     

    I have implemented the "=" for multiple prices edit as you request it.

     

    Fixed the ax missing .png. (thank you for noticing that)

     

    As for "Insert a link to the left column." you are right, although in the new upcoming version this is changed!

     

    Please stay tuned as the new version is on the way including your request and bug fixes.

  6. Hello.

     

    New version will be delayed a couple of days because I have implemented two new awesome features and I want to fully test them:

     

    Worldwide Clocks: you can see the current time at any city you like. You can setup as many as you want. This is helpful when you want to contact a customer, and you want to know the time in his city.

     

    Calendar: a full calendar where you can save, edit, delete events. Events can be set up daily, weekly, monthly or hourly. For example: you may need to contact a customer at 11:30 tomorrow morning.

     

    Please check the screenshots:

     

    post-284725-0-68952700-1381336410_thumb.png post-284725-0-57225100-1381336427_thumb.png

  7. That looks great. I'm assume attritbutes are not going to be edited across multiple products based on earlier comments about copy and delete attributes and their values.

     

    With 0.2 version you ll have the ability, among others to:

     

    Copy attributes from a product to another product

    Copy attributes from a product to other selected products

    Copy attributes from a product to all products in a category (recursively or not)

     

    Delete attributes from selected products

    Delete attributes from products in a category (recursively or not)

     

    Editing attributes can be done manually per product. (Maybe I'll find a nice way to mass edit attributes)

  8. Please have a look at the two attached images.

     

    post-284725-0-13430300-1380026909_thumb.png

     

    Thanks to highcharts.com and my coding passion i have created an online users viewer. I included in AAS although it can stand as a separate addon.

     

    In second screenshot you can also see from which countries are the online users, by using the ip and ip2country.

     

    Do you want that feature to be included in the new upcoming version 0.2 ?

     

    And a general question: Would you ever pay for such an addon (Alternative Administration System) ?

  9. I now realize that price including tax isn't a database entry and the Gross price effects the Net price in the regular product edit page, but only net is posted to the database. It would be great to add that feature into AAC.

     

    Yes the price including tax is not a database entry. Right now you can only edit the net price. Since you requested it, i will make it possible to change the gross price.

     

    I have a question: Net price is the original without taxes and gross the final with taxes. Am I right?

  10. In previous post i mentioned the new things that are on the way. Such as copy,move,link products, copy or delete products attributes e.t.c.

     

    Well, here are two new things not mentioned before:

     

    A ) embedded Attributes Manager. Now you can forget the default oscommerce Attributes page and use the new AAS: Attributes Manager (which is for now embedded in AAS: Categories/Products)

     

    Why use it? Because you can easily and quickly add, delete,edit options names and values via ajax.

     

    I have also implemented something thats missing from default products attributes page. Thats the feature to delete attributes values and names that are already assigned to products. By default osc does not allow you to delete, providing a message that is not safe to delete if any attribute is assigned to product or products. (I do not know if that feature will be useful for someone)

     

    B ) import method. You can edit a csv or txt file (that has already been exported via export method) with your favorite editor and then upload it easily via drag & drop. After drag & drop you can preview the changes and then apply if wanted.

     

    Have a look at the attached screenshots:

     

    post-284725-0-17684800-1379682503_thumb.jpg post-284725-0-66687600-1379682845_thumb.jpg

     

    On the first image you can see Attributes Manager. I edit an option value.

     

    On the second one you can see on the left side a small panel in where you can save products from different categories in a temp list. And yes you can export those products, edit them with excel for example and use the import method to apply changes.

     

    On the third one, you can see on the bottom of the page a new panel. Including the way to move, copy, link products and copy or delete attributes

  11. Thanks for your reply John.

    Try "háčky čárky řepa".

     

    Truth is, I'm adding this to oscmax 2.5 where the database is set to utf8_czech_ci, also I've checked that all pages are UTF-8 and of course the charset is set to UTF-8. I found somewhere that the code is 'javascript escape characters' and can be decoded, but its not too handy.

     

    function js_decode($string){
    $trans=array(
    "\u0160" => "Š",
    "\u017d" => "Ž",
    "\u0161" => "š",
    "\u017e" => "ž",
    "\u00c1" => "Á",
    "\u00c9" => "É",
    "\u00da" => "Ú",
    "\u00dd" => "Ý",
    "\u00e1" => "á",
    "\u00e4" => "ä",
    "\u00e9" => "é",
    "\u00ed" => "í",
    "\u00fa" => "ú",
    "\u00fd" => "ý",
    "\u010c" => "Č",
    "\u010d" => "č",
    "\u010e" => "Ď",
    "\u010f" => "ď",
    "\u011a" => "Ě",
    "\u011b" => "ě",
    "\u013e" => "ľ",
    "\u0147" => "Ň",
    "\u0148" => "ň",
    "\u0158" => "Ř",
    "\u0159" => "ř",
    "\u0164" => "Ť",
    "\u0165" => "ť",
    "\u016e" => "Ů",
    "\u016f" => "ů",
    "\u017d" => "Ž",
    "\u017e" => "ž",
    "\\" =>'');
    return strtr($string , $trans);
    }
    

     

    Also I would like to ask about the fields in your contribution. Is it possible to add extras? Oscmax had product fields like 'products_short' and I will have my own 'product_youtube' field.

     

    Thanks!

     

    Hi Fyod.. The háčky čárky řepa" submitted correctly, i did not have any problems with encoding. Maybe it has something to do with the your database being set to utf8_czech_ci, i will check it in a fresh instal of oscmax with utf8_czech_ci and i tell you..

     

    As for your last question " Is it possible to add extras? Oscmax had product fields like 'products_short' and I will have my own 'product_youtube' field." the answer is ABSOLUTELY YES and again YES.

     

    That's the power of AAS. Well it does not recognize by itself the extra fields, so you have to edit the config.php file and add those fields in the associative array. You will find instructions in the config.php file.

    If the field is simple, which means you just want to click and edit lets say the product_youtube then you just enter the apporpriate product_youtube data in the associative array.

    If the field is special (not usally) like a drop down menu then you have to edit the tbl.php and the tbl_ajax.php which stores the values to db.

     

    Your question generated me an idea to auto recognize the extra fields on products table and enabled them by default. That would be awesomely easy for non developers.

  12. The ability to copy attributes from a product to selected products or to all products of a category (thats tough) requested by Jabbathe22 would be awesome! I just installed your addon and like it better than the AJAX Attribute Manager although AJAX does allow defining sets of attributes that can be copied to other products.

     

    I need to figure out how to add options_values_weight to show up in the attributes. I have mods that add this to the weight just like the options_values_price so it would be nice to add that. I thought I saw some mention that there were instructions on how to add attributes but I could not find them (unless it was something planned for the future).

     

    Hello Dave.

     

    Yes i have already implemented the ability to copy attributes from a product to selected products and to all products under a category.

    Well, this feature is awesome i know, but i wanted it to be more awesome, so you will be able to enter any product in a temp products list and then copy attributes from a product to that temp products list. That means that you can "save" products from different categories to that list and then apply the attributes.

    You will also be able to copy, move, link products from selected products to a category.

     

    In general the new things are:

     

    Temp Products List (in where you can enter products from different categories). You can export those products! Edit attributes and description and view data of that products

     

    Copy attributes from a product to selected products or to selected products that are in the temp products list or to all products under a category.

     

    There are 3 options to perform that copy:

    1: delete existing attributes before applying the new ones,

    2: allow duplicate values

    3: disallow duplicate values

     

    Delete attributes from selected products or from selected products that are in the temp products list or from a category.

     

    (Performing actions in categories it is recursive, which means that if you select lets say the TOP category then all the attributes will be deleted or copied to all the products)

     

    Copy, move, link multiple products from selected products to other categories.

     

    New and easy way to edit product's description. Product previews are enabled by default.

    Now you can edit description in many possible languages. Without changing the default language.

     

    And all that actions are performed easily via ajax as always.

     

    I have improved - cleaned code and fixed some bugs.

     

    In a couple of days I will upload the new version.

     

    My addon does not yet has the possibility to add option values, option values price e.t.c.

    That will be in the new addon I am planning, the Alternative Administration System: Attributes Manager

  13. This seems to me a great product administration interface.

     

    When I downloaded the add-on only I could find pagination.php file, under admin sub-folder rest of the files were not there. Where can I find the rest of the files. I am in urgent need please reply it today.

     

    Hello raviranjans go to that link http://addons.oscommerce.com/info/8895 and click on the tab History, then download the full package I uploaded on 1 Sep 2013

  14. Some Notes: I have found some bugs with the description editors (those bugs occur when using the editors inside a jquery ui dialog), so i will get rid of that dialog in favor of..... thats a surprise...

     

    (Doing it like that, you will be able to change the description on different languages without changing the selected language from the dropdown menu on the bottom)

     

    ToDo Implementations:

     

    Copy Selected product/s to ...

    Move Selected product/s to ...

     

    Clone all attributes from a product to selected products or to all products of a category (thats tough) requested by Jabbathe22

     

    Please, if you have any feature requests, you can post them in this topic.

     

    Thank you.

  15. Yes, I just double-checked, and those have been added to catalog/admin/includes/filenames.php.

     

    Having my admin directory named differently should not affect anything right?

     

     

    P.S. - thanks for the quick response. I watched your video and getting this installed would really increase efficiency for OsCommerce.

     

    No having admin directory named differently does not affect anything.

     

    I dont know what produces this error. Please find my skype_id from my profile page on this forum and contact me to solve it.

     

    Thank you.

  16. Hey, this looks like a great addon, but I'm getting the following error when I try to navigate to the tbl.php page.

     

     

     

    Internal Server Error

     

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

     

     

     

    Please help!

     

    Hello Jabbathe22, are you sure you have added those

     

     define('FILENAME_TBL', 'tbl.php');
     define('FILENAME_TBL_AJAX', 'tbl_ajax.php');
     define('FILENAME_TBL_ACTIONS', 'tbl_actions.php');

     

    in the catalog/admin/includes/filenames.php?

  17. Hi, John,

     

    This is a really good add-on, which I am trialling at the moment. It has enormous potential: well done, and thanks.

     

    However, I have found three glitches so far, two are irritating, and the other a real problem.

     

    The first is that occasionally, seemingly at random (ie. I haven't quite worked out why it happens of what causes it - except see below), [submit Changes] has no effect, and it is necessary to back out a couple of levels, or sometimes to go right back to the traditional Admin screen, in order to clear it. Of course, changes made are lost.

     

    The second is that <shift-delete> works, but <shift-insert> doesn't; it requires Ctrl-V in order to paste. I could live with this, except that <shift-insert> is one of the causes of the failure of [submit Changes] above, and the one I habitually use.

     

    The serious problem is with the editor. There are several problems here.

     

    Clicking on a drop-down menu has the expected result, but it is not possible to dismiss the drop-down without choosing an option.

     

    Show Blocks does not work consistently, which compounds the problem below.

     

    This one is a killer for me. It seems that is not possible to insert raw HTML into a product description. For instance, and specifically in my case, <br />, which comes out in the description as literal text. This makes it very hard to lay out text properly.

     

    It also seems that once some text has been put into a paragraph, it is not possible to add a new paragraph, or another block.

     

    I accept that I may be mis-using the editor, in which case some guidance would be appreciated, but there is definitely a case for allowing people to have access to raw HTML.

     

    Regards, Laurie.

    To add to the above, the "Clear Formatting" Menu option had no effect, which again, compounds the problems with the editor.

     

    Regards, Laurie.

     

    Hello Laurie.

     

    I do not know why [Submit Changes] has no effect randomly, thats strange maybe it has something to do with the data submitted? Can you please provide me with more information?

     

    About the editor: you have two possible editors to use the default is "tinymce" and "ckeditor", Just change the value from config.php: 'productsDescriptionEditor' to ckeditor

    to enable the ckeditor which has the ability to insert raw html

     

    And yes I can confirm that the dropdownn menus from editors have some problems.

    Maybe because they are located in a dialog pop up.

    I will try to fix it.

     

    Regards, John.

  18. Hi John,

     

    Fantastic ad-on mate...

     

    I have noticed a few bugs with my installation.

     

    No Manufactures show in the dropdown fields

    Unable to update any values (will allow to edit but will not update)

    No Tax class showing in dropdown fields

    error when changing settings (Something went wrong! Please contact webmaster in order to solve this.)

     

    any help would be appreciated, thanks in advance.

     

    Ben

     

    Please find my skype_id from my profile page on this forum and contact me to solve those issues.

     

    Thank you.

  19. The warning will shown up in condition, which is when I set the Max products = ALL.

     

    Veego

     

    In order not to produce this warning:

    Change the line 73 in pagination.php from:

     

    $numOfPages=$rows / $this->perPage;
    

     

    to

     

    $numOfPages = $this->perPage>0 ? $rows / $this->perPage : 0;

     

     

    I have added the updates and the small bug fix in http://addons.oscommerce.com/info/8895

     

    Thank you.

  20. Hi John,

     

    That is a great Addon.

     

    But I have to following problem base on catalog/admin/includes/boxes/catalog.php. Pls advise.

     

    array(

    'code' => FILENAME_TABLEDATA,

    'title' => TBL_LINK_TITLE,

    'link' => tep_href_link(FILENAME_TABLEDATA)

    },

     

     

    When I finished installed, the Admin page show the link title as 'TBL_LINK_TITLE' seems it was undefine, and original file was define the 'TBL_LINK_TITLE' on catalog/admin/includes/languages/english/tbl.php. But when I add a new link to catalog/admin/includes/languages/english.php.

    This Title 'Alternative Administration System' in Admin page will reappear.

     

    Also the FILENAME_TABLEDATA also undefine, the original being define in filename.php were

    define('FILENAME_TBL', 'tbl.php');

    define(FILENAME_TBL_AJAX','tbl_ajax.php');

    define(FILENAME_TBL_ACTIONS','tbl_actions.php');

     

    but there is no FILENAME_TABEDATA, I guess the link in Alternative Administration System should access the tbl.php. so i change to the following.

     

    array(

    'code' => FILENAME_TBL,

    'title' => TBL_LINK_TITLE,

    'link' => tep_href_link(FILENAME_TBL)

    },

     

    And the 'Alternative Administration System' in Admin panel will redirect to the page you show us on youtube.

     

    Please correct me If I'm wrong.

     

    Veego

     

    Hello Veego yes you are right. It was my mistake.

    I will update the instructions as soon as possible.

     

    array(
    'code' => FILENAME_TBL,
    'title' => TBL_LINK_TITLE,
    'link' => tep_href_link(FILENAME_TBL)
    ),

     

    and then add

    define('TBL_LINK_TITLE','Alternative Administration System');

    in the english.php

×
×
  • Create New...