New Idea
(1)

Magento 2

by markoshust 1 x Certified on ‎03-18-2015 07:23 PM

Can we have a dedicated Magento 2 section setup someplace? I think that would make sense -- I wasn't sure if it was desired to keep the major versions flat agains the forums though... 

(2)

Can we get a Magento-Imagine specific discussion area somewhere on here? One for all Magento events would be *great*, but for now, just getting started with one for Magento Imagine would be nice. 

 

It would be a good way to let people know about things like #preimagine, it could help people setup ride shares to/from the airport, and otherwise just help the entire community get pumped for Imagine. 

 

 

Way to view users

by Moderator on ‎03-10-2015 06:36 AM

Will we have a way to view who is online, who is a user?

 

Will we have a list of moderators?

 

(1)

My first reaction was re-click the button, but nothin happened.

0 Kudos

Prevent Magento with Windows Firewall to block Semalt, Fraud countries, hackers, spam and more...
I have a Windows server with Magento and is focused on the European and US/Canadian market.
Every day my server is attacked by hackers and spammers mostly from fraud countries.
Now you can easily protect your Windows server with this very simple script against it.
You can block a country and/or countries/continents with it.
Most fraud countries are on the list and you can add more or remove them.
You can use this script for Windows 7, 8 and 8.1 systems.
Download the RAR file (protect_your_server.rar) from:
http://stackoverflow.com/questions/29865928/windows-firewall-to-block-semalt-fraud-countries-spam-an...
Insert here also your comments and/or new ideas, please


I hope that I can make a lot of people happy with this script! :smileyvery-happy:

Best regards, Rolf

0 Kudos

Net@Work's Dean Pagliaro provides an in-depth review of the benefits of a full ERP with an embedded eCommerce platform like Magento. What are some issues you've encountered with this integration?

 

Check out the article from Find Accounting Software here: http://findaccountingsoftware.com/expert-advice/everything-you-ever-wanted-to-know-about-erp-and-eco...

0 Kudos

Net@Work's Dean Pagliaro provides an in-depth review of the benefits of a full ERP with an embedded eCommerce platform like Magento. What are some issues you've encountered with this integration?http://findaccountingsoftware.com/expert-advice/everything-you-ever-wanted-to-know-about-erp-and-eco...

0 Kudos

I will like that Magento integrate more marketing solution into their plarteform, like Google Adwords Shopping, SEO rank tracker, etc. No other ecommerce platoform do to and it will still increases value of Magento ecommerce solution.

 

-- Best regards --

 

Jacques Nadeau - Webmarketing Expert / Visit my site

 

 

0 Kudos

Hi there,

 

I'm trying to set up a price cart rule to do the following:

 

If you spend $50 then you receive a $10 gift card for free.

If you spend $100 then you receive a $20 gift card for free.

and so on...

 

However, I don't want the customer to have to put the gift card into their cart, I just want it to automatically be included if the subtotal meets the specific criteria.

 

So basically is there any way to automatically give a product for free if the subtotal meets a specific amount?

 

Any help is much appreciated!!

 

Thanks!

0 Kudos

I ran into a problem recently when wanting to change customers a handling fee of $12 if they did not meet the minimum order limit of $100. The answer was to always have a $12 handling fee, but then give a $12 discount if the order minimum was met.

 

This is what worked for me:

Shipping Method Settings:
    Flat Rate - Enabled
        Title - UPS Ground (Will be $0 at time of sale if order minimum has been met)
        Type - Per Order
        Price - 12
        Sort Order - 1

    UPS - Enabled
        Allowed Methods - Anything but Ground
        Free Shipping with Minimum Order Amount - Disabled
        Sort Order - 2

Rule Settings:
    Rule Information
        Rule Name - Minimum Order Limit Met
        Description - Order is less than minimum, so a flat rate shipping charge will be applied
    Conditions
        If ALL  of these conditions are TRUE :
            Subtotal  equals or greater than  100
    Actions
        Apply - Fixed amount discount for whole cart
        Discount Amount - 12
        Apply to Shipping Amount - Yes

0 Kudos

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$productArr = [];
$tmpFilename = $_FILES["docname"]["tmp_name"];
// $file = 'var/importexport/bulkdynamic.csv';
$csv = new Varien_File_Csv();
$data = $csv->getData($tmpFilename);
$rows = count($data[0]);
$attributeCode = array();
$attributeCodewithId = array();
for ($j = 16; $j<= $rows; $j++) {

$cols = $data[0][$j];
if(!empty($cols)){
$attributeCode[] = $cols;
}
}
foreach($attributeCode as $code){

$attribute_details = Mage::getSingleton("eav/config")->getAttribute('catalog_product', $code);
$attribute = $attribute_details->getData();
$attribute_id = $attribute['attribute_id'];
if($attribute_id){
$attributeCodewithId[$code] = $attribute_id ;
}else{
echo "Error : ".$code."is not Valid";
break;
exit;
}


}
foreach ($data as $value) {

$cat = Mage::helper('bulkupload')->getCategoryNameById($value[3]);
$websiteId = Mage::app()->getWebsite()->getId();

if($value[1]=='simple'){
$simpleProduct = Mage::getModel('catalog/product');
try {


$simpleProduct
->setWebsiteIds(array($websiteId)) //website ID the product is assigned to, as an array
->setAttributeSetId($value[15]) //ID of a attribute set named 'default'
->setTypeId($value[1]) //product type
->setCreatedAt(strtotime('now')) //product creation time
->setSku($value[0]) //SKU
->setName($value[2]) //product name
->setWeight($value[6])
->setStatus(1) //product status (1 - enabled, 2 - disabled)
->setTaxClassId(0) //tax class (0 - none, 1 - default, 2 - taxable, 4 - shipping)
->setVisibility(1); //not visible visibility
$cnt = 16;
$optionLabelArr = array();
foreach($attributeCode as $code){
$set = 'set'.$code;
$optionLabelArr[] = $value[$cnt];
$optionId = Mage::helper('bulkupload')->getOptionId($code,$value[$cnt]);
$simpleProduct->$set($optionId);
$cnt++;
}

$simpleProduct->setNewsFromDate('') //product set as new from
->setNewsToDate('') //product set as new to
->setPrice($value[7]) //price in form 11.22
->setSpecialPrice('') //special price in form 11.22
->setSpecialFromDate('') //special price from (MM-DD-YYYY)
->setSpecialToDate('') //special price to (MM-DD-YYYY)
->setMetaTitle($value[8])
->setMetaKeyword($value[10])
->setMetaDescription($value[9])
->setDescription($value[4])
->setShortDescription($value[5]);
if(!empty($value[14])){
$galleryData = explode(',',$value[14]);
$simpleProduct->setMediaGallery(array('images'=>array (), 'values'=>array ()));
foreach($galleryData as $gallery_img) {
if ($gallery_img){
$simpleProduct->addImageToMediaGallery($gallery_img, array ('image','small_image','thumbnail'), false, false);
}
else{
$err = 1;
Mage::getSingleton('core/session')->addError($this->__('Image Path of '.$value[0].' Not Exist !!!'));
}
}
}
$simpleProduct->setStockData(array(
'use_config_manage_stock' => 0, //'Use config settings' checkbox
'manage_stock' => 1, //manage stock
'min_sale_qty' => 1, //Minimum Qty Allowed in Shopping Cart
'max_sale_qty' => 2, //Maximum Qty Allowed in Shopping Cart
'is_in_stock' => 1, //Stock Availability
'qty' => $value[11] //qty
)
)

->setCategoryIds(array($cat));
$simpleProduct->save();
echo "SKU:".$value[0].'&nbsp;added sucessfully'."<br />";
} catch (Exception $e) {
Mage::log($e->getMessage());
//echo $e->getMessage();
echo "SKU:".$value[0].'&nbsp;added unsucessfully'."<br />";
}
}
}
}

0 Kudos

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$productArr = [];

$tmpFilename = $_FILES["docname"]["tmp_name"];
$csv = new Varien_File_Csv();
$data = $csv->getData($tmpFilename);
$skuArr = array();
foreach ($data as $value) {
$skuArr[] = $value[0];
$attributeColorCode = 'color';
$attributeSizeCode = 'size';

// return function to getting the attribute color id

$attribute_details = Mage::getSingleton("eav/config")->getAttribute('catalog_product', $attributeColorCode);
$attribute = $attribute_details->getData();
$attribute_colorid = $attribute['attribute_id'];

// return function to getting the attribute size id

$attribute_details = Mage::getSingleton("eav/config")->getAttribute('catalog_product', $attributeSizeCode);
$attribute = $attribute_details->getData();
$attribute_sizeid = $attribute['attribute_id'];

$optionColorId = Mage::helper('bulkupload')->getOptionId($attributeColorCode,$value[15]);
$optionSizeId = Mage::helper('bulkupload')->getOptionId($attributeSizeCode,$value[16]);
$cat = Mage::helper('bulkupload')->getCategoryNameById($value[3]);
if($value[1]=='simple'){
$simpleProduct = Mage::getModel('catalog/product');
try {

$simpleProduct
->setWebsiteIds(array(1)) //website ID the product is assigned to, as an array
->setAttributeSetId($value[17]) //ID of a attribute set named 'default'
->setTypeId($value[1]) //product type
->setCreatedAt(strtotime('now')) //product creation time
->setSku($value[0]) //SKU
->setName($value[2]) //product name
->setWeight($value[6])
->setStatus(1) //product status (1 - enabled, 2 - disabled)
->setTaxClassId(0) //tax class (0 - none, 1 - default, 2 - taxable, 4 - shipping)
->setVisibility(1) //catalog and search visibility
->setColor($optionColorId)
->setSize($optionSizeId)
->setNewsFromDate('') //product set as new from
->setNewsToDate('') //product set as new to
->setPrice($value[7]) //price in form 11.22
->setSpecialPrice('') //special price in form 11.22
->setSpecialFromDate('') //special price from (MM-DD-YYYY)
->setSpecialToDate('') //special price to (MM-DD-YYYY)
->setMetaTitle($value[8])
->setMetaKeyword($value[10])
->setMetaDescription($value[9])
->setDescription($value[4])
->setShortDescription($value[5]);
if(!empty($value[14])){
$galleryData = explode(',',$value[14]);
$simpleProduct->setMediaGallery (array('images'=>array (), 'values'=>array ()));
foreach($galleryData as $gallery_img) {
if ($gallery_img){
$simpleProduct->addImageToMediaGallery($gallery_img, array ('image','small_image','thumbnail'), false, false);
}
else{
$err = 1;
Mage::getSingleton('core/session')->addError($this->__('Image Path of '.$value[0].' Not Exist !!!'));
}
}
}
$simpleProduct->setStockData(array(
'use_config_manage_stock' => 0, //'Use config settings' checkbox
'manage_stock' => 1, //manage stock
'min_sale_qty' => 1, //Minimum Qty Allowed in Shopping Cart
'max_sale_qty' => 2, //Maximum Qty Allowed in Shopping Cart
'is_in_stock' => 1, //Stock Availability
'qty' => $value[11] //qty
)
)
// $cat = $this->getCategoryNameById($value[3]);
->setCategoryIds($cat); //assign product to categories
$simpleProduct->save();

$productId = $simpleProduct->getId();

$simpleProductArr[] = $productId;

} catch (Exception $e) {
Mage::log($e->getMessage());
echo $e->getMessage();
}
}


/* Configurable Product Insert Section */

if(count($simpleProductArr)>0 && $value[1]=='configurable'){
$configProduct = Mage::getModel('catalog/product');
try {
$configProduct
// ->setStoreId(1) //you can set data in store scope
->setWebsiteIds(array(1)) //website ID the product is assigned to, as an array
->setAttributeSetId($value[17]) //ID of a attribute set named 'default'
->setTypeId($value[1]) //product type
->setCreatedAt(strtotime('now')) //product creation time
// ->setUpdatedAt(strtotime('now')) //product update time
->setSku($value[0]) //SKU
->setName($value[2]) //product name
->setWeight($value[6])
->setStatus(1) //product status (1 - enabled, 2 - disabled)
->setTaxClassId(0) //tax class (0 - none, 1 - default, 2 - taxable, 4 - shipping)
->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH) //catalog and search visibility
//->setManufacturer(28) //manufacturer id
//->setColor($value[15])
//->setSize($value[16])
->setNewsFromDate('') //product set as new from
->setNewsToDate('') //product set as new to
->setPrice($value[7]) //price in form 11.22
->setSpecialPrice('') //special price in form 11.22
->setSpecialFromDate('') //special price from (MM-DD-YYYY)
->setSpecialToDate('') //special price to (MM-DD-YYYY)
->setMetaTitle($value[8])
->setMetaKeyword($value[10])
->setMetaDescription($value[9])
->setDescription($value[4])
->setShortDescription($value[5]);
if(!empty($value[14])){
$galleryData = explode(',',$value[14]);
$configProduct->setMediaGallery (array('images'=>array (), 'values'=>array ()));
foreach($galleryData as $gallery_img) {
if ($gallery_img){
$configProduct->addImageToMediaGallery($gallery_img, array ('image','small_image','thumbnail'), false, false);
}
else{
$err = 1;
Mage::getSingleton('core/session')->addError($this->__('Image Path of '.$value[0].' Not Exist !!!'));
//$this->_redirect('musbury/index/index/');
}
}
}
$configProduct->setStockData(array(
'use_config_manage_stock' => 0, //'Use config settings' checkbox
'manage_stock' => 1, //manage stock
'min_sale_qty' => 1, //Minimum Qty Allowed in Shopping Cart
'max_sale_qty' => 2, //Maximum Qty Allowed in Shopping Cart
'is_in_stock' => 1, //Stock Availability
'qty' => $value[11] //qty
)
)
// $cat = $this->getCategoryNameById($value[3]);
->setCategoryIds($cat); //assign product to categories

$simpleProducts = Mage::getResourceModel('catalog/product_collection')
->addIdFilter($simpleProductArr)
->addAttributeToSelect('color')
->addAttributeToSelect('size')
->addAttributeToSelect('price');
$configProduct->setCanSaveConfigurableAttributes(true);
$configProduct->setCanSaveCustomOptions(true);

$configProduct->getTypeInstance()->setUsedProductAttributeIds(array($attribute_colorid,$attribute_sizeid)); //attribute ID of attribute 'color' in my store
$configurableAttributesData = $configProduct->getTypeInstance()->getConfigurableAttributesAsArray();
$configProduct->setCanSaveConfigurableAttributes(true);
$configProduct->setConfigurableAttributesData($configurableAttributesData);
$configurableProductsData = array();

foreach ($simpleProducts as $simple) {
$productData = array(
'label' => $simple->getAttributeText('color'),
'attribute_id' => $attribute_colorid,
'value_index' => (int) $simple->getColor(),
'is_percent' => 0,
'pricing_value' => $simple->getPrice()
);

$configurableProductsData[$simple->getId()] = $productData;
$configurableAttributesData[0]['values'][] = $productData;

$productData = array(
'label' => $simple->getAttributeText('size'),
'attribute_id' => $attribute_sizeid,
'value_index' => (int) $simple->getSize(),
'is_percent' => 0,
'pricing_value' => $simple->getPrice()
);

$configurableProductsData[$simple->getId()] = $productData;
$configurableAttributesData[1]['values'][] = $productData;
}
$configProduct->setConfigurableProductsData($configurableProductsData);

$configProduct->setConfigurableAttributesData($configurableAttributesData);
$configProduct->setCanSaveConfigurableAttributes(true);



Mage::log($configurableProductsData, null, 'configurableProductsData.log', true);
Mage::log($configurableAttributesData, null, 'configurableAttributesData.log', true);

$configProduct->save();
$confId = $configProduct->getId();

// saving the configurable option attribute price value

if($configProduct->getId()!='') {
$configurable = Mage::getModel('catalog/product')->load($confId);

$simpleProducts = Mage::getResourceModel('catalog/product_collection')
->addIdFilter($simpleProductArr)
->addAttributeToSelect('color')
->addAttributeToSelect('size')
->addAttributeToSelect('price');

$configurableProductsData = array();
$configurableAttributesData = $configurable->getTypeInstance()->getConfigurableAttributesAsArray();

foreach ($simpleProducts as $simple) {
$productData = array(
'label' => $simple->getAttributeText('color'),
'attribute_id' => $attribute_colorid,
'value_index' => (int) $simple->getColor(),
'is_percent' => 0,
'pricing_value' => $simple->getPrice()
);

$configurableProductsData[$simple->getId()] = $productData;
$configurableAttributesData[0]['values'][] = $productData;

$productData = array(
'label' => $simple->getAttributeText('size'),
'attribute_id' => $attribute_sizeid,
'value_index' => (int) $simple->getSize(),
'is_percent' => 0,
'pricing_value' => $simple->getPrice()
);

$configurableProductsData[$simple->getId()] = $productData;
$configurableAttributesData[1]['values'][] = $productData;
}

$configurable->setConfigurableProductsData($configurableProductsData);
$configurable->setConfigurableAttributesData($configurableAttributesData);
$configurable->setCanSaveConfigurableAttributes(true);
Mage::log($configurableProductsData, null, 'configurableProductsData.log', true);
Mage::log($configurableAttributesData, null, 'configurableAttributesData.log', true);
$configurable->save();
$simpleProductArr = array();
echo "SKU:".$value[0].'&nbsp;added sucessfully'."<br />";
}
} catch (Exception $e) {
$simpleProductArr = array();
Mage::log($e->getMessage());
echo "SKU:".$value[0].'&nbsp;added unsucessfully'."<br />";
}

}
}
}

0 Kudos

Can we PM a user?

by seansan 4 weeks ago

For example I am trying to reach "Brent W Peterson"

 

and would like to attend him (or other editor) to this link

 

request: Can we add a PM feature to this board?

0 Kudos

Hi i need to Style the product-collateral box on product detail page .

can we display the description , additional information tabs without using tab, can we show them all in 2 columns so user no need to click tabs thanks

0 Kudos

Easier to find private messaging

by PlacementEdge on ‎03-23-2015 04:24 PM

I wanted to send a private message and it took me a really long time to find the link viewing a members profile.

0 Kudos

Making More Easier With Integrations

by solemtech on ‎03-20-2015 04:35 AM

Hello.

 

As many of us know, integrating something with Magento is a complicated process and there is a really low documentation. So,

We have our own api and integration framework compatible with Magento to integrate ERP softwares such as SAP. Our api works with directly databases. As i mentioned before, it is complicated and needs to be make more easier with an official framework. Don't mention Magento Soap api please :smileyhappy: It is very slow. 

 

So, any ideas? Because like us many company makes their own api for integrate somethings with Magento. I think we can talk these processes right here.