Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

[abcisme]

Hi All,

I'm running 1.3.9h no Super Orders or Tracker installed. I'm using Edit Orders v3.0. I have read about what's happening to me in this thread but there is no answer. I just have Spanish Language and English installed, the main language is Spanish, the problem is when Adding a Product, I select Category --- Subcategory and when displaying products they are displayed in mixed language, the first 3 products are displayed in Spanish then the next 5 are in English. What should I modify?

Regards.

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

[abcisme]

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

Here's a screenshot of what I mean:



There doesn't seem to be any rhyme or reason to it.

[Darkwander]

Greetings;

I am getting the following error on top of the page, am i suppose to follow the instructions and delete the file;

Error The auto-loader /home/delights/public_html/store/****/includes/auto_loaders/config.eo.php has not been deleted. For this module to work you must delete this file manually.

[abcisme]

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

Not sure if this is the correct code to modify, but can it be modified to somehow specify to select only products with a specific language_id?

        // ############################################################################
    //   Get List of All Products
    // ############################################################################

    //$result = zen_db_query("SELECT products_name, p.products_id, x.categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " x ON x.categories_id=ptc.categories_id ORDER BY categories_id");
        $result = $db -> Execute("SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name");
        #hile($row = zen_db_fetch_array($result))         {
      while (!$result -> EOF){
            extract($result->fields,EXTR_PREFIX_ALL,"db");
            $ProductList[$db_categories_id][$db_products_id] = $db_products_name;
            $CategoryList[$db_categories_id] = $db_categories_name;
            $LastCategory = $db_categories_name;
         $result -> MoveNext();
        }

        // ksort($ProductList);

        $LastOptionTag = "";
        $ProductSelectOptions = "<option value='0'>Don't Add New Product" . $LastOptionTag . "\n";
        $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
        foreach($ProductList as $Category => $Products)
        {
            $ProductSelectOptions .= "<option value='0'>$Category" . $LastOptionTag . "\n";
            $ProductSelectOptions .= "<option value='0'>---------------------------" . $LastOptionTag . "\n";
            asort($Products);
            foreach($Products as $Product_ID => $Product_Name)
            {
                $ProductSelectOptions .= "<option value='$Product_ID'> &nbsp; $Product_Name" . $LastOptionTag . "\n";
            }

            if($Category != $LastCategory)
            {
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
            }
        }
    // ############################################################################
    //   Add Products Steps
    // ############################################################################ 

[DivaVocals]

Wish I could help, but the answer is a LOT over my head.. Hopefully someone else in the community knows the answer and will share..

Not sure if this is the correct code to modify, but can it be modified to somehow specify to select only products with a specific language_id?

        // ############################################################################
    //   Get List of All Products
    // ############################################################################

    //$result = zen_db_query("SELECT products_name, p.products_id, x.categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " x ON x.categories_id=ptc.categories_id ORDER BY categories_id");
        $result = $db -> Execute("SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name");
        #hile($row = zen_db_fetch_array($result))         {
      while (!$result -> EOF){
            extract($result->fields,EXTR_PREFIX_ALL,"db");
            $ProductList[$db_categories_id][$db_products_id] = $db_products_name;
            $CategoryList[$db_categories_id] = $db_categories_name;
            $LastCategory = $db_categories_name;
         $result -> MoveNext();
        }

        // ksort($ProductList);

        $LastOptionTag = "";
        $ProductSelectOptions = "<option value='0'>Don't Add New Product" . $LastOptionTag . "\n";
        $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
        foreach($ProductList as $Category => $Products)
        {
            $ProductSelectOptions .= "<option value='0'>$Category" . $LastOptionTag . "\n";
            $ProductSelectOptions .= "<option value='0'>---------------------------" . $LastOptionTag . "\n";
            asort($Products);
            foreach($Products as $Product_ID => $Product_Name)
            {
                $ProductSelectOptions .= "<option value='$Product_ID'> &nbsp; $Product_Name" . $LastOptionTag . "\n";
            }

            if($Category != $LastCategory)
            {
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
            }
        }
    // ############################################################################
    //   Add Products Steps
    // ############################################################################ 

[abcisme]

Wish I could help, but the answer is a LOT over my head.. Hopefully someone else in the community knows the answer and will share..

Man, I hope so. I just don't understand why it's showing some products listed in English and some in French. It makes no sense. There must be some way to compile the product list in only one language, using a "WHERE language_id = 1" condition in that query somewhere.. I just have NO CLUE what the syntax would be or how to go about implementing it. I'm kind of glad to know it isn't just me having the problem though.

[chava1106]

does anyone know of anyway to make this work for version 1.5?


Its really important!!!!

[laurelsstitchery]

does anyone know of anyway to make this work for version 1.5?


Its really important!!!!

Did you read post #470? It's only three pages back.

[DivaVocals]

Did you read post #470? It's only three pages back.

Which is again why I always suggest reading through the support threads BEFORE posting...

[ted]

does anyone know of anyway to make this work for version 1.5?


Its really important!!!!

The new version Diva has on the website works fine, just installed and used it. So you can wait until they get the readmes tweaked and it gets in the Zen Plugins as stated or download it from the website. I had no problems installing and using the current install instructions.