Sub remove_columns()
For i = ActiveSheet.Columns.Count To 1 Step -1
If InStr(1, Cells(1, i), "offer") Then Columns(i).EntireColumn.Delete
Next i
End Sub

cmd as admin
slmgr -rearm

What you have to realize is that if you apply this fix while you can still see your desktop background, it will rearm the system for another 30 days, up to a maximum of 3 times.

If you apply the fix after you lose your background (ie your desktop wallpaper background goes black, and you get the notification at the bottom right of the screen), you need to first uninstall the kb971033 update, then apply the fix. It will then be a PERMANENT fix. If you're running a Remove WAT program, WAT needs to be restored first. ...

SELECT p.product_id, p.status, p.create_date, ep.start_date, ep.end_date, ei.item_id
FROM m2epro_listing_product p
LEFT JOIN m2epro_ebay_listing_product ep ON p.id = ep.listing_product_id
LEFT JOIN m2epro_ebay_item ei ON ei.id = ep.ebay_item_id
WHERE (ep.end_date +36000) < NOW()
AND p.status = 2;

SOLUTION:
select distinct a.firstname,a.lastname,a.telephone from sales_flat_order_address a
inner join sales_flat_order o on o.shipping_address_id = a.entity_id
where o.store_id = 5 or o.store_id = 6

Solution:

SELECT DISTINCT o.customer_email, o.customer_firstname, o.customer_lastname, o.store_id FROM sales_flat_order_item i
INNER JOIN sales_flat_order o ON o.entity_id = i.order_id
WHERE o.customer_id IS NOT NULL
AND i.sku = 'B/BVP700'

SOLUTION:
Reindex Catalog Search Index

SOLUTION:

Reindex, refresh all cache

SOLUTION:

Within the catalog_category_entity table we noticed that the children_count of some of the categories had negative numbers in them. We thought that was just plan odd. How could a category have negative categories when the entire system is based on there is x children or there simply is not. -

Count (physically) and change that negative number to the correct number (children count)

short:
DELETE
FROM catalog_product_entity_decimal
WHERE attribute_id =567
AND store_id !=0;

DELETE
FROM catalog_product_entity_varchar
WHERE attribute_id IN (96, 106, 109, 493)
AND store_id !=0;

DELETE
FROM catalog_product_entity_int
WHERE attribute_id =273
AND store_id !=0;

DELETE
FROM catalog_product_entity_datetime
WHERE attribute_id=569
AND store_id!=0;

DELETE FROM catalog_product_entity_text WHERE attribute_id = 506 AND store_id != 0;

default values for 'special price'
DELETE
FROM `catal...

Solution: ex.
sudo find / -name '*' -size +500M
sudo find / -size +10M -size -12M -ls

Solution:
zip -r filename.zip folderpath

This happens when errors occur while generating feeds. The TMP files never get deleted and they will be appended to the 'final result'.
This might cause doubles, triples, and more in a datafeed.

Solution: log on FTP, go to /media/productsfeed , delete all TMP files, problem solved.

Reindex processes seem stuck on "Index Management"
Solution: log on FTP, go to docs/var/locks - delete the index.locks files, problem solved

Solution: reindex CATEGORY FLAT DATA, problem solved.

Tried installing an extension via Connect Manager, installed successfully, cleared cache, and it did not show up in Magento
Checked System - Configuration - Advanced - Advanced - Disable Output Module, it was not there!

SOLUTION: Manually install using FTP

Some of the items on Reindex Management page stucked for 2 days
"Reindex required", however when clicked on, it said the process was still processing.

Turned out that when an error occurred during reindex (php errors), the locks in var/locks would be stuck there, and would not be deleted unless done manually.

Solution: go to var/locks and delete all process locks files in there, reindex one by one manually.

ISSUE:
Place a test order at one of our ebay stores
Got 2 emails (of the same order) with different Magento order ids
(only one exists!)
http://screencast.com/t/4iIGjkLFb

STC: 2 emails -> same order id
ADO: different order ids (both order incremented from last count)
BG: different order ids (one of the ids seems to be stuck: 200030582, the other incremented)

SOLUTION:
Turned off Apache/MySql on old server.