Jump to content

 

The Tool

Member Since 30 Mar 2007
Offline Last Active Jan 25 2020 02:26 PM
*****

#110432 Quickbooks

Posted by The Tool on 19 April 2011 - 08:00 AM

As far as I know, the problem(s) is not the actual creation of the file but when you import the created file into Quickbooks, then multiple errors occur and not all the information is imported. I imagine the problem is the format of the created file?


#99658 XML Data Feed(Importing supplier's xml)

Posted by The Tool on 05 January 2011 - 03:47 PM

Tool: Can I ask several questions;

1.How can you convert these csv's to xml? with the help of Excel?
2.Are you using CS-Cart CSV import tool or just done via database?
3.How you filter/understand new products and changed/updated prices?Isn't it difficult to scan all products to understand if they are new or their prices are updated or not?
4.How you're applying some margin to the suppliers' costs?You mentioned about the formula to apply some profit,can you share with us about how you did it?


1. I do not convert to xml...it stays as a csv file. Yes, I use Excel to edit the csv file obtained from the supplier.
2. Yes, I use the CSC import/export.
3. This is handled differently between my 2 suppliers because data is different. One of my suppliers offers 2 files: 1 is changes and the other is the complete current products available. My other supplier only offers 1 file but it includes a field "Modified Date" which tells me when a product has been changed.
4. I create another field "Price" in the csv and add a formula for example B2*.4+B2 (B2 being the suppliers cost) then drag the formula down the list of products.


#97777 Product Sorting v2.x

Posted by The Tool on 11 December 2010 - 04:32 PM

Tool: could you share the code you added to make "Bestsellers" appear in the sortings?


That is/was actually standard. I am assuming they have removed it?

Once CSC gets their shit straight (to my standards) with 2.1.x, I will then upgrade and be more familiar with the code and once again be of help to the forum. :P


#80663 Format Date to DD-MM-YYY

Posted by The Tool on 21 May 2010 - 04:36 PM

Settings->Appearance under Common Settings


#65395 Minimum Price (Subtotal) To Checkout

Posted by The Tool on 28 December 2009 - 01:01 PM

This is a repost for version 2.x.

The problem is that the minimum order amount is set to allow checkout for the entire order (subtotal, shipping, tax) instead of just the subtotal. This is what and where the changes need to be made to allow checkout with the minimum of the subtotal. The code can be found at the very end of the file and you just simply need to change "total" to "subtotal" in the following:

/core/fn.cart.php
// Checks if order can be placed
//
function fn_allow_place_order(&$cart)
{
	$[COLOR="Blue"]subtotal[/COLOR] = $cart['[COLOR="Blue"]subtotal[/COLOR]'];

	fn_set_hook('allow_place_order', $total, $cart);

	$cart['amount_failed'] = (Registry::get('settings.General.min_order_amount') > $[COLOR="Blue"]subtotal[/COLOR] && floatval($[COLOR="Blue"]subtotal[/COLOR]));

	if (!empty($cart['amount_failed']) || !empty($cart['shipping_failed'])) {
		return false;
	}

	return true;
}