great development, the web interface!
ran into a few problems:
1) first tried to install outside root (in test directory)
couldn’t get it to works (likely because it couldn’t find prototype/prototype.js mentioned in mmi.php)
installed it in the root to avoid other errors
- config was no problem, however for novice users like me: check your directory permissions - script should have write access so it can create the ini file
2) when i select the file i want to import, script gives me:
Warning: file_get_contents(./tmp_out.txt) [function.file-get-contents]: failed to open stream: No such file or directory in /home/(etc)mmi/mmiweb/progress.php on line 5
Warning: Cannot modify header information - headers already sent by (output started at /home/(etc)/mmi/mmiweb/progress.php:5) in /home/(etc)/mmi/mmiweb/progress.php on line 86
I think it needs to exist (or my permissions might be wrong) - after creating it (placed empty txt file in dir with write permissions), it started working
3) also had problems with quantity 0
when qty=0 in csv it sets item to manage stock = no, instead of just setting the quantity to 0
if qty is over 0, it works fine
short sidenote here: we use a lot of different stock options depending on own stock, supplier stock, supplier status, manufacturer status etc etc - herefore all our stock and backorder statusses are managed on product level - would be really cool if there’s a way to get the magento export values for these settings to be imported by mmi too.
(export values: min_qty, use_config_min_qty, is_qty_decimal, backorders, use_config_backorders, min_sale_qty, use_config_min_sale_qty, max_sale_qty, use_config_max_sale_qty, is_in_stock)
4) Multi website:
getting the following sql error when using the same product on 2 lines (1 for admin entry, 1 for different price on 2nd website):
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ON DUPLICATE KEY UPDATE `value`=VALUES(`value`)’ at line 3
different values for same product on other website seem ok so far - will continue testing
- another multi website issue:
when an item is in website ‘base’ and you add another website, it goes ok
if an item is currently on 2 different websites and you remove one of them, it is not updated correctly - stays on both websites
Hope this helps - always ready to test some more!