Jump to content
surfalot

[Contribution] Availability

Recommended Posts

Hello,

I've installed the contrib, which is great, I've been waiting for it for some time.

Everything went well, the catalog/product_info.php works but in the admin side I have some problems.

Here are the images:

 

This is the admin/availability_options.php

 

options.jpg

 

This is what I get when I click the Edit button:

 

edit.jpg

 

The same I get when I click the Insert new options button

 

This is the configuration page, just in case...

 

configuration.jpg

 

From what I've read in this thread it's a language problem but I have no idea where to start. I use romanian language.

 

Thank you in advance

Best regards

Share this post


Link to post
Share on other sites
Hello,

I've installed the contrib, which is great, I've been waiting for it for some time.

Everything went well, the catalog/product_info.php works but in the admin side I have some problems.

 

That's interesting. Try this:

open the file /admin/availability_options.php, find the line:

if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {

replace with:

if ( (sizeof($heading) > 0) && (sizeof($contents) > 0) ) {

let me know if that fixes the "insert new option".

 

the included content is setup for english.

 

Run this in your host supplied database management tool (phpMyAdmin for most) to clear the English content:

 

TRUNCATE  TABLE  `availability`

 

Then, replace the number "1" in the second field for each line that follows, with the numeric value for your language and run the SQL in your database management tool to insert the content for your language. You can translate the language before or after inserting it in the database.

 

INSERT INTO `availability` VALUES (1, 1, '%s in stock.');
INSERT INTO `availability` VALUES (2, 1, 'Temporarily out of stock.');
INSERT INTO `availability` VALUES (3, 1, 'In stock, usually ships within 1 to 3 days.');
INSERT INTO `availability` VALUES (4, 1, 'In stock, usually ships within 4 to 7 days.');
INSERT INTO `availability` VALUES (5, 1, 'Temporarily out of stock, restocking is expected shortly.');
INSERT INTO `availability` VALUES (6, 1, 'Special order, arrival dates may vary.');
INSERT INTO `availability` VALUES (7, 1, 'Made to order.');
INSERT INTO `availability` VALUES (8, 1, 'Made to order, usually ships within 3 to 7 days.');
INSERT INTO `availability` VALUES (9, 1, 'Made to order, usually ships within 7 to 14 days.');

 

so if your language code is 4, then it will look like this:

 

INSERT INTO `availability` VALUES (1, 4, '%s in stock.');
INSERT INTO `availability` VALUES (2, 4, 'Temporarily out of stock.');
INSERT INTO `availability` VALUES (3, 4, 'In stock, usually ships within 1 to 3 days.');
INSERT INTO `availability` VALUES (4, 4, 'In stock, usually ships within 4 to 7 days.');
INSERT INTO `availability` VALUES (5, 4, 'Temporarily out of stock, restocking is expected shortly.');
INSERT INTO `availability` VALUES (6, 4, 'Special order, arrival dates may vary.');
INSERT INTO `availability` VALUES (7, 4, 'Made to order.');
INSERT INTO `availability` VALUES (8, 4, 'Made to order, usually ships within 3 to 7 days.');
INSERT INTO `availability` VALUES (9, 4, 'Made to order, usually ships within 7 to 14 days.');

Share this post


Link to post
Share on other sites

Hello surfalot, thank you for the quick reply. I've made the mods and now I have the flags showing up, but the problem still remains. I want to mention that I have the OSC M2 installed. I know that there are a few variable incompatibilities between M2 and RC2. Might this be the problem?

 

edit1.gif

 

Thank you.

Best regards.

Share this post


Link to post
Share on other sites

that didn't show anything. There is something wrong with the php on your server. near the bottom of /admin/availability_options.php

 

replace this

  if ( (sizeof($heading) > 0) && (sizeof($contents) > 0) ) {
echo '			<td width="25%" valign="top">' . "\n";

$box = new box;
echo $box->infoBox($heading, $contents);

echo '			</td>' . "\n";
 }

with this:

	echo '			<td width="25%" valign="top">' . "\n";

$box = new box;
echo $box->infoBox($heading, $contents);

echo '			</td>' . "\n";

Share this post


Link to post
Share on other sites

HELLLLLP!!!

 

 

After a while, I could install and make all the stuff to work. It seems to be really good, but...

 

 

my problem is:

 

- in product info page (product_info.php) I can only see: "Availability: " . There is nothing write after the "availability"...

 

I have already tried:

 

- delete the availability itens (available, made to order, etc) and create new ones

- set the language

- create new product and define the mensages I want to see in both the cases (in stock and out of stock)

 

 

PLEASE, what should I do???

Thanks

Share this post


Link to post
Share on other sites

how many languages are in your shop?

 

Find this in product_info.php:

 

$availability_query = tep_db_query("select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id");

 

after, add this temporarily, load the product_info.php page from your browser. Then copy and post the text it displays that starts with "select * from" and "number of rows".

 

echo '<br><br>' . "select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id";
echo '<br>number of rows=' . tep_db_num_rows($availability_query);
exit:

 

remove the code.

Share this post


Link to post
Share on other sites
how many languages are in your shop?

 

Find this in product_info.php:

 

$availability_query = tep_db_query("select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id");

 

after, add this temporarily, load the product_info.php page from your browser. Then copy and post the text it displays that starts with "select * from" and "number of rows".

 

echo '<br><br>' . "select * from ".TABLE_AVAILABILITY." where language_id = " . $languages_id . " order by availability_id";
echo '<br>number of rows=' . tep_db_num_rows($availability_query);
exit:

 

remove the code.

 

Hello,

 

I have this problem, too

It wouldn't work with your code :((

I have 4 languages in my shop and the first is german not english. Maybe the problem?

When I write in my SQL-DB the language ID '1' (german) ---> then the DB overwrite in '2'?!

In admin/categories I see all flags, datas right! But in the shop, in the product-info and shopping-cart, I see only in german language the datas, but not in the other 3 languages :(

Pleeeaaaase help me and the other users here on board, they have the same problem

And: Sorry for my baaaaaaaaaaaaaaaaaaaaaaaaad english ;)

 

fairy

Share this post


Link to post
Share on other sites
Hello,

 

I have this problem, too

It wouldn't work with your code :((

I have 4 languages in my shop and the first is german not english. Maybe the problem?

When I write in my SQL-DB the language ID '1' (german) ---> then the DB overwrite in '2'?!

In admin/categories I see all flags, datas right! But in the shop, in the product-info and shopping-cart, I see only in german language the datas, but not in the other 3 languages :(

Pleeeaaaase help me and the other users here on board, they have the same problem

And: Sorry for my baaaaaaaaaaaaaaaaaaaaaaaaad english ;)

 

fairy

I have the answer!

show under:

http://forums.oscommerce.de/index.php?s=&a...st&p=322986

it is in german, because my english isn't so good ;)

if somebody translated here my text in English, this would be great :)

 

greetz

Share this post


Link to post
Share on other sites

Wow, that wasn't very helpful at all. I still don't know what the problem is, and since nobody is willing to follow though with helping me help you track it down, I guess it just won't get fixed. <_< Works fine for me, I guess that is all that matters, ay?

Share this post


Link to post
Share on other sites

Hello Guys,

 

thanks for this nice contribute.

 

The contribute works fine. But if I would like to press the button „configurer” it shows me the line below.

 

Warning: require_once(languages/german/availability_configurer.php) [function.require-once]: failed to open stream: No such file or directory in /is/htdocs/xxxxxxxxx/xxxx/xxxxx/includes/availability_configurer.php on line 27

 

Fatal error: require_once() [function.require]: Failed opening required 'languages/german/availability_configurer.php' (include_path='.:/usr/share/pear/php5') in /is/htdocs//xxxxxxxxx/xxxx/xxxxx/includes/availability_configurer.php on line 27

 

 

Well in the file availability_configurer.php line 27 shows:

 

27 require('includes/application_top.php');

 

 

The file application_top.php is at the right place.

 

 

 

Someone have an idea to solve this error?

 

 

Thanks!

Share this post


Link to post
Share on other sites
Hello Guys,

 

thanks for this nice contribute.

 

The contribute works fine. But if I would like to press the button „configurer” it shows me the line below.

 

Warning: require_once(languages/german/availability_configurer.php) [function.require-once]: failed to open stream: No such file or directory in /is/htdocs/xxxxxxxxx/xxxx/xxxxx/includes/availability_configurer.php on line 27

 

Fatal error: require_once() [function.require]: Failed opening required 'languages/german/availability_configurer.php' (include_path='.:/usr/share/pear/php5') in /is/htdocs//xxxxxxxxx/xxxx/xxxxx/includes/availability_configurer.php on line 27

 

 

Well in the file availability_configurer.php line 27 shows:

 

27 require('includes/application_top.php');

 

 

The file application_top.php is at the right place.

 

 

 

Someone have an idea to solve this error?

 

 

Thanks!

 

that is because the language files are supplied only in english. I may have forgotten the instruction in the install directions, but any time you install a contribution, and it includes a language file or changes to a language file, it is up to you to make sure those change/additions get pushed to all the languages you have installed and use.

 

So anything added by this contribution that resides in /catalog/includes/languages/english/ or /catalog/admin/includes/languages/english/ or /catalog/includes/languages/english.php or /catalog/admin/includes/languages/english.php should be also added to your /german/ folders and files.

Share this post


Link to post
Share on other sites
that is because the language files are supplied only in english. I may have forgotten the instruction in the install directions, but any time you install a contribution, and it includes a language file or changes to a language file, it is up to you to make sure those change/additions get pushed to all the languages you have installed and use.

 

So anything added by this contribution that resides in /catalog/includes/languages/english/ or /catalog/admin/includes/languages/english/ or /catalog/includes/languages/english.php or /catalog/admin/includes/languages/english.php should be also added to your /german/ folders and files.

 

 

thanks for request.

 

mmmhh, I've translated all language files in german language. But I've forgotten to add the files in german directory later.

 

I will add the german files to the contribution.

 

thanks

Share this post


Link to post
Share on other sites

Hi,

 

Everything work for me, except when i go to the Admin > Catalog > Availability and tried to edit or add the options.

I do not get the right column section.

 

I'm sure it is simple... but can't find it :(

Share this post


Link to post
Share on other sites
Hi,

 

Everything work for me, except when i go to the Admin > Catalog > Availability and tried to edit or add the options.

I do not get the right column section.

 

I'm sure it is simple... but can't find it :(

 

That is not the first I've heard of that. The only thing I can think of right now is that maybe you haven't modified or uploaded the languages files into the language that is being used currently in the admin.

Share this post


Link to post
Share on other sites

Hi!

I appreciated this contrib as it solved many problems I was facing.

 

I'd like to know how to make the "Availability" tex in red color and bigger font, and leave the messages as they are...even thought it would be nice to know how to change them too.

 

Thank you.

Share this post


Link to post
Share on other sites
I'd like to know how to make the "Availability" tex in red color and bigger font, and leave the messages as they are

you can put html tags in the text like this

<font color="red" size="3">Ships 3 days from order date</font>

even thought it would be nice to know how to change them too.

if installed correctly, there is a utility that should be under the Admin > Catalog > Availability that you can change the text. there should be link in the product edit page to the utility also.

Edited by surfalot

Share this post


Link to post
Share on other sites
you can put html tags in the text like this
<font color="red" size="3">Ships 3 days from order date</font>

 

if installed correctly, there is a utility that should be under the Admin > Catalog > Availability that you can change the text. there should be link in the product edit page to the utility also.

 

Hello and thx for stopping by.

I was considering the "Availability" text only and not the edited text.

Share this post


Link to post
Share on other sites
Hello and thx for stopping by.

I was considering the "Availability" text only and not the edited text.

I don't understand, is there still an issue?

Share this post


Link to post
Share on other sites
I don't understand, is there still an issue?

With the code you pasted you will change the availability text.

I was asking about writing AVAILABILITY: in different color too.

Share this post


Link to post
Share on other sites
With the code you pasted you will change the availability text.

I was asking about writing AVAILABILITY: in different color too.

 

you can change the title word in the language files:

/catalog/includes/languages/english/product_info.php

\catalog/includes/languages/english/shopping_cart.php

 

and any other languages you have edited to include this.

 

look for

// BOF: Availability
define('TABLE_HEADING_AVAILABILITY', 'Availability:');
// EOF: Availability

Share this post


Link to post
Share on other sites
That is not the first I've heard of that. The only thing I can think of right now is that maybe you haven't modified or uploaded the languages files into the language that is being used currently in the admin.

 

 

Thank you for the contribution!

Everything works great on my local server but on the website, problem showing right column section at Admin > Catalog > Availability. when I hit the button edit or add the options. I do not get the right column section

I've updated exactly same files to website. Check the files several times.. just weird. Both local and website are using Mysql5.0, PHP5. Help! Thank you.

Share this post


Link to post
Share on other sites
Thank you for the contribution!

Everything works great on my local server but on the website, problem showing right column section at Admin > Catalog > Availability. when I hit the button edit or add the options. I do not get the right column section

I've updated exactly same files to website. Check the files several times.. just weird. Both local and website are using Mysql5.0, PHP5. Help! Thank you.

are you using the admin in a language other then english? if so, have you copied the language file(s) and any changes to the global english.php to each of the other languages you use on the admin side?

Share this post


Link to post
Share on other sites
are you using the admin in a language other then english? if so, have you copied the language file(s) and any changes to the global english.php to each of the other languages you use on the admin side?

 

I'm using only english setting. copied the language files and also made changes to the global english.php

Basically it works great on local server but not showing right column on the website. My only option would be using phpMyAdmin..

Thank you for your help.

Share this post


Link to post
Share on other sites
I'm using only english setting. copied the language files and also made changes to the global english.php

Basically it works great on local server but not showing right column on the website. My only option would be using phpMyAdmin..

Thank you for your help.

 

are you absolutely certain those English language files actually got uploaded?

 

Do you have Admin Access Levels contribution installed? (adds multi-level multi-account access to the admin)

 

When you are seeing that you are missing the right column, post to me everything after the /availability_options.php? part of the URL in the address bar of your browser.

 

EX: page=1&action=new&osCAdminID=d1f3fbd898ecbfa46f0fa5da389e25b3

Edited by surfalot

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×