New 
gadlol
-
Posts
241 -
Joined
-
Last visited
-
Days Won
13
Posts posted by gadlol
-
-
You can find the new addon here: http://addons.oscommerce.com/info/8895
I will not answer to this thread.
Use the new : http://www.oscommerce.com/forums/topic/394327-alternative-administration-system-categoriesproducts/
Thank you.
-
You can find the addon here: http://addons.oscommerce.com/info/8895
Hope you like it.
If you have any requests or find any bug or whatever please reply to this post...
Thank you.
-
Unfortunately i cannot upload the addon because when i try to upload it always says Error: All fields required
I have entered all the required data but....
Maybe there's a problem with the addons page. Can someone confirm that?
-
Alternative Administration System: Categories/Products. is an alternative way to navigate through categories to easily find and EDIT products. It has its own ui totally different from the default admin one. You simply navigate to a php page and voila!!!
Note: Alternative Administration System: Categories/Products is child of Alternative Administrator Categories/Products Page Addon (jQuery, ajax edit)Some features:
-
Add extra custom fields easily
-
All fields custom or not, can be editable or not, visible by default or not , sortable or not e.t.c.
-
You can also add fields from other mysql tables other than products
-
All fields custom or not, can be editable or not, visible by default or not , sortable or not e.t.c.
-
Deletion of multiple products
-
Multiple prices edit
-
Right side panel (sortable fields, choose what fields to display and sort - reorder them)
-
Bottom panel (contains: categories list, languages, display in stock or not)
-
Top Search panel (hidden by default, opens when you click on search icon)
-
Server side pagination (includes max products per page)
-
Advanced search (search on specific field, developers can add their own custom fields)
-
Order products by different fields - custom fields
-
Print categories and/or products (only the categories - products table, everything else is not displayed )
-
Multiple product status change
-
Export products into csv, json, text or excel file
I will post the addon at the addons page shortly
Have a look at the screenshots:
Youtube demo:
-
Add extra custom fields easily
-
Hi!
I'm trying to use some special characters when editing but it's not working. For example, if I edit using "ú" it would change to "ú" at the store side. Am I missing something?
Thank you!
I will check it soon!
The fully functional version is about to be released just wait a few more days! Still debugging - adding new things such as: display price (net) and (gross).
-
The implode function needs an array as an argument.
So you get this warning because
tep_parse_category_path($cPath);
returns null not an array
SO second thing to be done is ti check the $cPath variable and check the tep_parse_category_path() function
-
Hi,
I am now debugging it.
Although its in a stable status, there are some micro things to be done, such as when the session is timeout and you click to ajax edit products price then it must open a dialog saying session is timeout please login again.
For this to happen I must do a small micro change to application_top.php so not to automatically redirect to login page (only for this addon)
There are also the translations to be done!
The products reorder feature is awesome.
You can click on a row and move it up or down and all the products on that page are automatically reordered. So simple!
-
First try to see what tep_parse_category_path($cPath) returns
do:
$cPath_array = tep_parse_category_path($cPath); var_dump($cPath_array); $cPath = implode('_', $cPath_array); $current_category_id = $cPath_array[(sizeof($cPath_array)-1)];Is $cPath_array an array?
-
New features added:
- Add extra custom fields easily (for developers: associative arrays)
- All fields custom or not, can be editable or not, visible by default or not , sortable or not e.t.c.
- You can also add fields from other mysql tables other than products (you must add the necessary query text (select , from , where) on the array $_EXTRA_FIELDS )
- All fields custom or not, can be editable or not, visible by default or not , sortable or not e.t.c.
-
Deletion of multiple products
-
Multiple prices edit (redifned)
- Right side panel (sortable fields, choose what fields to display and sort - reorder them)
- Bottom panel (contains: categories list, languages, display in stock or not)
- Top panel (hidden by default, opens when you click on search icon)
-
Server side pagination (includes max products per page)
-
Advanced search (search on specific field, developers can add their own custom fields)
- Order products by different fields - custom fields
-
Print categories and/or products (only the categories - products table, everything else is not displayed )
- Tooltips
Features removed:
- Sortable fields from settings dialog (you can always sort them from the right side panel)
To be done:
- Make table rows sortable (so when you change the order of rows then also changes the order of products under their category)
- Multiple products change status
There will be instructions for developers (how to add new fields, e.t.c.)
There will be no instructions on how to use the addon because I do not have time to do that.
I will, though, upload a short video on youtube, showing the new features!
Any feature requests before releasing the new version?
Do you want the ability to preview a product that is not active - out of stock while editing description?
John
- Add extra custom fields easily (for developers: associative arrays)
-
-
xmmm nice but later i will make a new attributes system, so i want something to be generic.
For example:
Alternative Administration System : Categories / Products
AAS:CP
Alternative Administration System : Attributes
AAS:A
Question: whats the difference between addon and contribution on oscommerce?
-
Information about this addon progress:
I have changed the code a lot so when version 0.2 will be realeased you have to replace everything (sorry for this).
By changing the code in such a clever way :- you can easily add new fields by just filling an array and ofcourse by adding the appropiate code to the tbl_ajax.php which stores values to db.
Note if you want to be able to use a select menu or something else despite simple text which can be editable, you have to hardcode the case in the switch case found in the tbl.php.
You can even display fields data without being able to edit them.
You will have instructions for all that!
A great addition I made, is the ability to mass edit products prices.
For example, I want in some values to lower the price by 10%.
I just select the products (through checkboxes) and enter the amount 10 and select the -% option on the dialog and press apply.
So easy. (Available options are: -% , +% , - , + )
Right now I am building a server side pagination system and i am thinking of making able the system to display - handle products that are specials.
And later my goal is to make a new attributes manager system because the osc original sucks a bit (sorry osc team).
Thats the news!!!
BUT I do not like the name of this addon.
So in order to release the next version WE must find another name.
I am thinking of:
Like a boss Osc Manager ( LaBOM )
Do you have any propositions?
-
getting a 404 when editing the Product preview
Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.
If you think this is a server error, please contact the "]webmaster.
Error 404
φοbερός, που εμπνέει δέος
in order for this to work you must edit 457 line of the tbl.php and change according to your store path.
//Used by iframe when previewing editing product description
//Change according your site. Exmp: 'http://www.mywebstore.com/product_info.php?products_id='
var product_info_path='http://localhost/osc2/catalog/product_info.php?products_id=';
I will change it in the final release, so this product_info_path variable will be auto generated...
Note in order to preview the product it must be on stock and availble!
-
hahahah yes
Oh ok i got it now sorry took a few seconds to click
nice real nice
looks like the editing/viewing product description is Greek but i guess i can learn.
Ευχaριστώ
hahaha yes its in Greek I forgot to change it. You will find instructions how to change it in this forum post.
I think you must learn Greek its a great language. You will discover its awesomeness while learning.
Πaρaκaλώ!
-
no i do not think so here is what i see but preview will not work screenshot
http://nationwidetrailerparts.com/images/output.gif[/img]
I see...
In order to make the preview dialogs apear you must click on the View/Edit button which is located in the Description column.
-
Hi John I followed your instructions but i think i am missing something the previews are not coming up the TBL page loads when i click on the folders it works but preview will not function any ideas?
I am using 2.3.1 thanks
Hi imageanative. Do the preview dialogs apear when you click the preview button (you must make apear the preview column )?
-
TBL v0.2 is still under developement...
Have a look at the screenshot.
Hope you like the new UI interface!
-
Sounds good! I did notice a large amount of tables and while they have their uses I can see it easily being done with div tags.
Couple of things I would like to see, which wont be realistic for large shops, are the ability to list all products and also to display more than 100 items per page. Its probably just a personal preference but I like to be able to have it all at my fingertips and then be able to search by model number for instance. My situation is when we do price checks on competitors we can easily pull up the product by model number and then change the prices.
You've put a lot of work into this and it is indeed a time saver for me and a preferred method over using Easypopulate.
Yes you will be able to display lots of products even more than 100 and of course all of them.
The search system is redisigned, you can search on a specific field or in all of them (well on those that are searchable!).
I am even thinking of making a mechanism for mass discounts. F.e. you will be able to check a little checkbox on the left of each table row and select a discount (10% for example) and den apply that to all selected prices! Is this feature needed?
Well the checkboxes on each product will also give other possibilites such as mass change of products statuses e.t.c.
-
I finally found some time to look at your code today. Youve made a lot of changes since your last version!
I found one step missing from what you had above.:
On line 678 I needed to add in p.products_cost :)
Ive got 7 more fields to add to it before Im done and one of them is a select.
Thanks for your help!
Hi EchoGuns, yes you are right. You must include the new field to the db query...
Well, i am not very satisfied with the code because right now i am using lots of variables for the different fields. So i am try to build it to be more flexible and less code.
I tried to keep it as dry as possible. I have to reconsider the use of variables, session variables e.t.c. Right now the tbl.php file is about 34.1 KB, i ll try to reduce it more. Maybe i will even remove the php comments - credits - changelog in the top of the tbl.php code
First thing i will remove is the jquery datatables, which has a pagination bug (when using it with jeditable), i cannot solve it, (when you are on second page and edit something it goes on first page and not in second).
So i will make a real pagination with php and not leave it to javascript because when a category has many products it takes lots of time to load all of them.
One second thing is that i will remove the onstock not on stock double key and use images instead because when you have many products it takes some time for jquery ui to create the nice loooking button elements...
I am also thinking of using a cache file system, simple cache though, file based. What do you think of it?
Update...
I forgot to mention that i will remove the lots of tables in favor of divs.
-
I have installed your newest version, I had your previous installed and had used it for quite some time and enjoyed it. After playing around with the newest version sofar I have found no problems with it so far.
I was wondering one thing however. Ive yet to look at the coding in this version but how easy would it be to modify this to accept more fields. I think the biggest example for most people is a 'Cost' field but I have several others as well and would love the ability to edit them in this.
Thanks!
Hello Clint.
In order to modified it to accept more fields its easy. Although you must know php. You must also know how this field will be presented. It will be a select menu or simple text.
Lets see how we are going to do this: Open for editing the catalog/admin/tbl.php
1: enter the field name on the array $columns line 118. f.e. 'products_cost'
2: add inside the switch($john) on line 146:
case 'products_cost': $bool_products_cost=true; break;
3: add inside the switch($john) on line 167:
case 'products_cost': $bool_products_cost=false; break;
4: add on line 191:
$bool_products_cost=false;
5: add on line 210:
$_SESSION['products_cost']=$bool_products_cost
6: on line 230 add
$bool_products_cost=$_SESSION['products_cost']
7: add inside the $show_always array(line 281):
'products_cost'=>true;
8:on line 307 add
if($show_always[0]['products_cost']) $bool_products_cost=true;
9:on line 332 add:
case 'products_cost': $show_bool=$bool_products_cost; $show_text=TBL_HEADING_COST; break;
NOTE: TBL_HEADING_COST does not exist and you must add it on the tbl.php which is located on the includes/languages/english folder.
10: on 359 add:
$show_product[] = array('show'=>$bool_products_cost, 'fieldName'=>'products_cost', 'theadText'=>TBL_HEADING_COST);Thats it.
If the cost is simple text then you must click on it and edit it via ajax it will ok. If it is a select menu you must goi and add a case a=on the big switch
switch($value['fieldName']){Check the case'tax_class_title': case.
Finally you must edit the tbl_ajax.php and add a case f.e. :
case 'products_cost': //product cost if(tep_not_null($product_id_post)){ if(tep_not_null($value_post)){ if(is_numeric($value_post)){ $sql_data_array = array('products_cost' => (float)tep_db_prepare_input($value_post),'products_last_modified' => 'now()'); if(tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$product_id_post . "'")) echo stripslashes($value_post); }else echo TBL_ERROR_NONUMERIC_VALUE; }else echo TBL_ERROR_EMPTY_VALUE; } break;Hope this helps!
In next vesrion i will make it more simple (you will have just to enter the filed name and everything will be automatically set up)
Regards John
-
Hi,
I have seen the video, downloaded and installed this brilliant looking add-on. I've followed the installations instructions to the letter, when it comes to running it however the scripting doesn't work.
Where in the video you click on an item and lightboxes appear with previews, attributes etc.. Mine doesn't. I've uploaded all the files in the download pack and nothings working. It appears that the stylesheet hasn't loaded either.
Thanks for the hlep in advance!
Dear hoprick
I dont know whats the problem exactly. You can send me screenshots to check them, out. Please check also the console for errors.
Please contact me on my skype account, so we can solve the problems together. You can find my skype account on my profile!
Regards John
-
Hi John, You are a genius! That add-on is way sweet! I want to use it on my OSC 2.3.3 but have a question. I have this store setup for a client that sells heated clothing and accessories and I pretty much done except one little glitch... And from what I have been reading, this issue is not a new one. I just don't know or can't figure out the best way of tackling it and I am hoping for your help! He sells a jacket and the sizes are XSmall, Small, Medium, Large, XLarge and 2XLarge. How can I setup the individual stock/quantity amounts for each one? For right now I can only set the stock/quantity amount for the jacket but need to break it out to setup amounts for each size. Some people have told me to use QTPro but it looks like overkill for what I want it for. I just want to manage how many sm, med, large, XLarge & 2XLarge sizes there are in stock for a product.
Your help is so appreciated, you have no idea!!
-Rick from Jersey
Dear Rick,
If you want to have individual stock/quantity amounts you must alter the core functionality of oscommerce. My addon cannot handle individual stock/quantity amounts because this functionality does not exist in oscommerce. So as i can imagine you must create a new table in db, (products_new_table_id, products_stock, products_quantity, products_size, products_id). Then you must make a page where you can setup this (this can be made on my addon) but the main fact is that you have to setup this in products_info page. When a user selects a size then (maybe with ajax) alter the prize and quantity. e.t.c.
Sorry for not answering sooner!
Regards John
-
Thanx a lot Sara...
Looking forward for any bug - error reports
Regards John
-
Alternative Administration System: Categories/Products
in General Add-Ons Support
Posted · Edited by gadlol
Hello razgre.
Yes Product Sort order Field is missing.
If you want to enable it you must apply this addon first: http://addons.oscommerce.com/info/8311 and then uncomment the line 156 in the config.php
Thank you.
Note: Product Sort order is not necessary for my addon to work, but I think if someone uses product sort order then my addon should help him order products easily...